Overview

Dataset info

Number of variables181
Number of observations20000
Missing cells2408219 (66.5%)
Duplicate rows0 (0.0%)
Total size in memory27.2 MiB
Average record size in memory1.4 KiB

Variables types

Numeric54
Categorical23
Boolean19
Date0
URL0
Text (Unique)1
Rejected84
Unsupported0

Warnings

coligada_mais_antiga_ativa has 17302 (86.5%) missing values Missing
coligada_mais_antiga_baixada has 19990 (> 99.9%) missing values Missing
coligada_mais_nova_ativa has 17302 (86.5%) missing values Missing
coligada_mais_nova_baixada is highly correlated with coligada_mais_antiga_ativa (ρ = 0.94271) Rejected
de_faixa_faturamento_estimado has 1154 (5.8%) missing values Missing
de_faixa_faturamento_estimado_grupo has 1154 (5.8%) missing values Missing
de_indicador_telefone has constant value "BOA" Rejected
de_nivel_atividade has 448 (2.2%) missing values Missing
de_saude_rescencia has 608 (3.0%) missing values Missing
de_saude_tributaria has 608 (3.0%) missing values Missing
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
dt_situacao has a high cardinality: 4215 distinct values Warning
empsetorcensitariofaixarendapopulacao has 6268 (31.3%) missing values Missing
faturamento_est_coligados is highly correlated with coligada_mais_nova_baixada (ρ = 0.91204) Rejected
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.99793) Rejected
fl_epp has constant value "False" Rejected
fl_optante_simei has 3538 (17.7%) missing values Missing
fl_optante_simples has 3538 (17.7%) missing values Missing
grau_instrucao_macro_analfabeto has 19930 (99.7%) missing values Missing
grau_instrucao_macro_desconhecido has constant value "nan" Rejected
grau_instrucao_macro_escolaridade_fundamental has 18909 (94.5%) missing values Missing
grau_instrucao_macro_escolaridade_media is highly skewed (γ1 = 27.975) Skewed
grau_instrucao_macro_escolaridade_media has 17060 (85.3%) missing values Missing
grau_instrucao_macro_escolaridade_superior has 19058 (95.3%) missing values Missing
idade_acima_de_58 has 19524 (97.6%) missing values Missing
idade_ate_18 has 19888 (99.4%) missing values Missing
idade_de_19_a_23 has 18870 (94.3%) missing values Missing
idade_de_24_a_28 has 18368 (91.8%) missing values Missing
idade_de_29_a_33 has 18292 (91.5%) missing values Missing
idade_de_34_a_38 is highly correlated with idade_de_29_a_33 (ρ = 0.96376) Rejected
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.95304) Rejected
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.92955) Rejected
idade_de_49_a_53 is highly correlated with idade_de_44_a_48 (ρ = 0.9679) Rejected
idade_de_54_a_58 is highly correlated with idade_de_49_a_53 (ρ = 0.94691) Rejected
idade_maxima_coligadas is highly correlated with coligada_mais_nova_baixada (ρ = 0.94271) Rejected
idade_maxima_socios has 6586 (32.9%) missing values Missing
idade_media_coligadas is highly correlated with coligada_mais_nova_baixada (ρ = 0.97597) Rejected
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.99868) Rejected
idade_media_coligadas_baixadas is highly correlated with idade_media_coligadas_ativas (ρ = 0.92832) Rejected
idade_media_socios is highly correlated with idade_maxima_socios (ρ = 0.95975) Rejected
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 0.99882) Rejected
idade_minima_socios is highly correlated with idade_media_socios (ρ = 0.95683) Rejected
max_faturamento_est_coligados is highly correlated with faturamento_est_coligados_gp (ρ = 0.94776) Rejected
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.99411) Rejected
max_filiais_coligados is highly correlated with coligada_mais_nova_baixada (ρ = 0.97946) Rejected
max_funcionarios_coligados_gp is highly correlated with coligada_mais_nova_baixada (ρ = 0.9016) Rejected
max_meses_servicos is highly correlated with idade_media_coligadas_baixadas (ρ = 0.97658) Rejected
max_meses_servicos_all has 15515 (77.6%) missing values Missing
max_vl_folha_coligados is highly correlated with max_filiais_coligados (ρ = 0.91799) Rejected
max_vl_folha_coligados_gp is highly correlated with max_vl_folha_coligados (ρ = 0.9144) Rejected
media_faturamento_est_coligados has 17332 (86.7%) missing values Missing
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.98196) Rejected
media_filiais_coligados is highly correlated with coligada_mais_nova_baixada (ρ = 0.98273) Rejected
media_funcionarios_coligados_gp is highly correlated with coligada_mais_nova_baixada (ρ = 0.93916) Rejected
media_meses_servicos is highly correlated with idade_media_coligadas_baixadas (ρ = 0.94844) Rejected
media_meses_servicos_all is highly skewed (γ1 = 23.838) Skewed
media_meses_servicos_all has 15515 (77.6%) missing values Missing
media_vl_folha_coligados has 18485 (92.4%) missing values Missing
media_vl_folha_coligados_gp has 18477 (92.4%) missing values Missing
meses_ultima_contratacaco is highly skewed (γ1 = 34.023) Skewed
meses_ultima_contratacaco has 15515 (77.6%) missing values Missing
min_faturamento_est_coligados is highly skewed (γ1 = 29.558) Skewed
min_faturamento_est_coligados has 17332 (86.7%) missing values Missing
min_faturamento_est_coligados_gp is highly skewed (γ1 = 40.941) Skewed
min_faturamento_est_coligados_gp has 17332 (86.7%) missing values Missing
min_filiais_coligados has 19201 (96.0%) missing values Missing
min_funcionarios_coligados_gp is highly skewed (γ1 = 28.164) Skewed
min_funcionarios_coligados_gp has 577 (2.9%) zeros Zeros
min_funcionarios_coligados_gp has 18262 (91.3%) missing values Missing
min_meses_servicos is highly skewed (γ1 = 35.627) Skewed
min_meses_servicos has 16703 (83.5%) missing values Missing
min_meses_servicos_all is highly correlated with meses_ultima_contratacaco (ρ = 0.9754) Rejected
min_vl_folha_coligados has 18485 (92.4%) missing values Missing
min_vl_folha_coligados_gp is highly correlated with min_funcionarios_coligados_gp (ρ = 0.93663) Rejected
nm_divisao has a high cardinality: 86 distinct values Warning
nm_meso_regiao has 2505 (12.5%) missing values Missing
nm_micro_regiao has a high cardinality: 74 distinct values Warning
nm_micro_regiao has 2505 (12.5%) missing values Missing
nu_meses_rescencia has 1905 (9.5%) missing values Missing
percent_func_genero_fem has 961 (4.8%) zeros Zeros
percent_func_genero_fem has 16721 (83.6%) missing values Missing
percent_func_genero_masc has 755 (3.8%) zeros Zeros
percent_func_genero_masc has 16721 (83.6%) missing values Missing
qt_admitidos is highly skewed (γ1 = 25.07) Skewed
qt_admitidos has 15515 (77.6%) missing values Missing
qt_admitidos_12meses is highly skewed (γ1 = 27.343) Skewed
qt_admitidos_12meses has 3209 (16.0%) zeros Zeros
qt_admitidos_12meses has 15515 (77.6%) missing values Missing
qt_alteracao_socio_180d has constant value "nan" Rejected
qt_alteracao_socio_365d has constant value "nan" Rejected
qt_alteracao_socio_90d has constant value "nan" Rejected
qt_alteracao_socio_total has constant value "nan" Rejected
qt_art is highly correlated with idade_media_coligadas_baixadas (ρ = 1) Rejected
qt_coligadas is highly skewed (γ1 = 20.236) Skewed
qt_coligadas has 17889 (89.4%) missing values Missing
qt_coligados is highly correlated with qt_coligadas (ρ = 0.99975) Rejected
qt_coligados_agropecuaria has 2533 (12.7%) zeros Zeros
qt_coligados_agropecuaria has 17290 (86.5%) missing values Missing
qt_coligados_atividade_alto has constant value "0.0" Rejected
qt_coligados_atividade_baixo has constant value "0.0" Rejected
qt_coligados_atividade_inativo has constant value "0.0" Rejected
qt_coligados_atividade_medio has constant value "0.0" Rejected
qt_coligados_atividade_mt_baixo has constant value "0.0" Rejected
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.99782) Rejected
qt_coligados_baixada has 17290 (86.5%) missing values Missing
qt_coligados_ccivil is highly skewed (γ1 = 26.521) Skewed
qt_coligados_ccivil has 2251 (11.3%) zeros Zeros
qt_coligados_ccivil has 17290 (86.5%) missing values Missing
qt_coligados_centro has 2549 (12.7%) zeros Zeros
qt_coligados_centro has 17290 (86.5%) missing values Missing
qt_coligados_comercio has 1422 (7.1%) zeros Zeros
qt_coligados_comercio has 17290 (86.5%) missing values Missing
qt_coligados_epp has 17290 (86.5%) missing values Missing
qt_coligados_exterior has 17290 (86.5%) missing values Missing
qt_coligados_inapta is highly correlated with coligada_mais_antiga_baixada (ρ = 0.937) Rejected
qt_coligados_industria is highly skewed (γ1 = 25.232) Skewed
qt_coligados_industria has 2293 (11.5%) zeros Zeros
qt_coligados_industria has 17290 (86.5%) missing values Missing
qt_coligados_ltda is highly skewed (γ1 = 24.669) Skewed
qt_coligados_ltda has 2587 (12.9%) zeros Zeros
qt_coligados_ltda has 17290 (86.5%) missing values Missing
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.99805) Rejected
qt_coligados_me has 17290 (86.5%) missing values Missing
qt_coligados_mei has 17290 (86.5%) missing values Missing
qt_coligados_nordeste has 1043 (5.2%) zeros Zeros
qt_coligados_nordeste has 17290 (86.5%) missing values Missing
qt_coligados_norte has 1813 (9.1%) zeros Zeros
qt_coligados_norte has 17290 (86.5%) missing values Missing
qt_coligados_nula has constant value "0.0" Rejected
qt_coligados_sa is highly correlated with idade_media_coligadas_baixadas (ρ = 0.91043) Rejected
qt_coligados_serviço has 1000 (5.0%) zeros Zeros
qt_coligados_serviço has 17290 (86.5%) missing values Missing
qt_coligados_sudeste is highly correlated with qt_coligados_matriz (ρ = 0.95437) Rejected
qt_coligados_sul is highly correlated with coligada_mais_nova_baixada (ρ = 0.91104) Rejected
qt_coligados_suspensa has 17290 (86.5%) missing values Missing
qt_desligados is highly correlated with qt_admitidos (ρ = 0.93477) Rejected
qt_desligados_12meses is highly skewed (γ1 = 35.828) Skewed
qt_desligados_12meses has 3181 (15.9%) zeros Zeros
qt_desligados_12meses has 15515 (77.6%) missing values Missing
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 1) Rejected
qt_filiais is highly skewed (γ1 = 20.326) Skewed
qt_filiais has 18181 (90.9%) zeros Zeros
qt_funcionarios is highly correlated with idade_de_54_a_58 (ρ = 0.9349) Rejected
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.99486) Rejected
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.97492) Rejected
qt_funcionarios_coligados is highly correlated with coligada_mais_nova_baixada (ρ = 0.94351) Rejected
qt_funcionarios_coligados_gp is highly correlated with max_funcionarios_coligados_gp (ρ = 0.99611) Rejected
qt_funcionarios_grupo has 1208 (6.0%) zeros Zeros
qt_funcionarios_grupo has 15052 (75.3%) missing values Missing
qt_ramos_coligados is highly correlated with idade_media_coligadas_baixadas (ρ = 0.91284) Rejected
qt_regioes_coligados has 17290 (86.5%) missing values Missing
qt_socios is highly correlated with idade_media_coligadas_baixadas (ρ = 0.93688) Rejected
qt_socios_coligados has 17290 (86.5%) missing values Missing
qt_socios_feminino has 13768 (68.8%) missing values Missing
qt_socios_masculino is highly correlated with qt_socios (ρ = 0.97996) Rejected
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.99002) Rejected
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.98016) Rejected
qt_socios_pj has 14854 (74.3%) zeros Zeros
qt_socios_pj has 4959 (24.8%) missing values Missing
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 0.96123) Rejected
qt_socios_pj_baixados has 19813 (99.1%) missing values Missing
qt_socios_pj_inaptos has 19813 (99.1%) missing values Missing
qt_socios_pj_nulos has 19813 (99.1%) missing values Missing
qt_socios_pj_suspensos has constant value "0.0" Rejected
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.98725) Rejected
qt_socios_st_suspensa is highly correlated with min_filiais_coligados (ρ = 1) Rejected
qt_ufs_coligados is highly correlated with idade_media_coligadas_baixadas (ρ = 0.92173) Rejected
sum_faturamento_estimado_coligadas is highly correlated with max_vl_folha_coligados (ρ = 0.9227) Rejected
total is highly correlated with qt_funcionarios_24meses (ρ = 0.96062) Rejected
total_filiais_coligados is highly correlated with max_vl_folha_coligados (ρ = 0.92829) Rejected
tx_crescimento_12meses is highly skewed (γ1 = 49.472) Skewed
tx_crescimento_12meses has 1933 (9.7%) zeros Zeros
tx_crescimento_12meses has 16819 (84.1%) missing values Missing
tx_crescimento_24meses is highly skewed (γ1 = 37.678) Skewed
tx_crescimento_24meses has 1185 (5.9%) zeros Zeros
tx_crescimento_24meses has 16772 (83.9%) missing values Missing
tx_rotatividade has 3489 (17.4%) zeros Zeros
tx_rotatividade has 15515 (77.6%) missing values Missing
vl_faturamento_estimado_aux is highly correlated with total (ρ = 0.97315) Rejected
vl_faturamento_estimado_grupo_aux is highly skewed (γ1 = 29.359) Skewed
vl_faturamento_estimado_grupo_aux has 1154 (5.8%) missing values Missing
vl_folha_coligados is highly correlated with total_filiais_coligados (ρ = 0.91586) Rejected
vl_folha_coligados_gp is highly correlated with vl_folha_coligados (ρ = 0.922) Rejected
vl_frota is highly correlated with qt_socios_pj_inaptos (ρ = 0.9575) Rejected
vl_idade_maxima_socios_pj is highly correlated with idade_media_coligadas_baixadas (ρ = 0.98969) Rejected
vl_idade_media_socios_pj is highly correlated with vl_idade_maxima_socios_pj (ρ = 0.95057) Rejected
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 0.91241) Rejected
vl_potenc_cons_oleo_gas has 19845 (99.2%) missing values Missing
vl_total_tancagem is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.99476) Rejected
vl_total_tancagem_grupo is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.90065) Rejected
vl_total_veiculos_antt is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.99317) Rejected
vl_total_veiculos_antt_grupo is highly correlated with vl_total_veiculos_antt (ρ = 1) Rejected
vl_total_veiculos_leves is highly correlated with vl_total_veiculos_antt_grupo (ρ = 0.9581) Rejected
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_antt (ρ = 0.95917) Rejected
vl_total_veiculos_pesados is highly correlated with vl_total_veiculos_antt_grupo (ρ = 0.97758) Rejected
vl_total_veiculos_pesados_grupo is highly correlated with vl_total_veiculos_antt (ρ = 0.97729) Rejected

Variables

coligada_mais_antiga_ativa
Numeric

Distinct count2256
Unique (%)11.3%
Missing (%)86.5%
Missing (n)17302
Infinite (%)0.0%
Infinite (n)0
Mean220.21
Minimum0.6
Maximum903.17
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.6
5-th percentile28.767
Q195.55
Median189.92
Q3303.69
95-th percentile579.39
Maximum903.17
Range902.57
Interquartile range208.14

Descriptive statistics

Standard deviation160.27
Coef of variation0.7278
Kurtosis0.687
Mean220.21
MAD126.46
Skewness1.0284
Sum5.9413e+05
Variance25686
Memory size312.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
629.97 15 0.1%
 
643.03 10 0.1%
 
635.07 7 < 0.1%
 
635 6 < 0.1%
 
263.63 5 < 0.1%
 
188.23 4 < 0.1%
 
43.567 4 < 0.1%
 
108.13 4 < 0.1%
 
385.07 4 < 0.1%
 
70.333 4 < 0.1%
 
Other values (2245) 2635 13.2%
 
(Missing) 17302 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0.6 1 < 0.1%
 
1.7667 1 < 0.1%
 
1.8 1 < 0.1%
 
1.9333 1 < 0.1%
 
2.1667 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
903.17 3 < 0.1%
 
820.1 1 < 0.1%
 
808.67 2 < 0.1%
 
788.6 1 < 0.1%
 
721.4 1 < 0.1%
 

coligada_mais_antiga_baixada
Numeric

Distinct count7
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)19990
Infinite (%)0.0%
Infinite (n)0
Mean101.51
Minimum19.2
Maximum190.9
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum19.2
5-th percentile24.975
Q164.517
Median83.967
Q3162.12
95-th percentile190.9
Maximum190.9
Range171.7
Interquartile range97.6

Descriptive statistics

Standard deviation65.161
Coef of variation0.64192
Kurtosis-1.2251
Mean101.51
MAD53.087
Skewness0.54341
Sum1015.1
Variance4246
Memory size312.5 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
83.967 4 < 0.1%
 
190.9 2 < 0.1%
 
58.033 1 < 0.1%
 
32.033 1 < 0.1%
 
188.17 1 < 0.1%
 
19.2 1 < 0.1%
 
(Missing) 19990 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
19.2 1 < 0.1%
 
32.033 1 < 0.1%
 
58.033 1 < 0.1%
 
83.967 4 < 0.1%
 
188.17 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
190.9 2 < 0.1%
 
188.17 1 < 0.1%
 
83.967 4 < 0.1%
 
58.033 1 < 0.1%
 
32.033 1 < 0.1%
 

coligada_mais_nova_ativa
Numeric

Distinct count1976
Unique (%)9.9%
Missing (%)86.5%
Missing (n)17302
Infinite (%)0.0%
Infinite (n)0
Mean110.8
Minimum0.6
Maximum635.43
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.6
5-th percentile4.8333
Q131.742
Median79.3
Q3159.56
95-th percentile330.8
Maximum635.43
Range634.83
Interquartile range127.82

Descriptive statistics

Standard deviation106.57
Coef of variation0.96187
Kurtosis2.5365
Mean110.8
MAD81.511
Skewness1.5325
Sum2.9893e+05
Variance11358
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
470.13 14 0.1%
 
9.2667 12 0.1%
 
1.5333 10 0.1%
 
2.7 9 < 0.1%
 
3.8 6 < 0.1%
 
78.333 6 < 0.1%
 
16.267 6 < 0.1%
 
71.467 5 < 0.1%
 
27.633 5 < 0.1%
 
13.033 5 < 0.1%
 
Other values (1965) 2620 13.1%
 
(Missing) 17302 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0.6 1 < 0.1%
 
1.3 1 < 0.1%
 
1.4667 2 < 0.1%
 
1.5 3 < 0.1%
 
1.5333 10 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
635.43 1 < 0.1%
 
634.4 1 < 0.1%
 
634.13 1 < 0.1%
 
604.37 1 < 0.1%
 
598.6 1 < 0.1%
 

coligada_mais_nova_baixada
Highly correlated

This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis

Correlation0.94271

de_faixa_faturamento_estimado
Categorical

Distinct count12
Unique (%)0.1%
Missing (%)5.8%
Missing (n)1154
DE R$ 81.000,01 A R$ 360.000,00
11790
ATE R$ 81.000,00
4370
DE R$ 360.000,01 A R$ 1.500.000,00
 
2000
Other values (8)
 
686
(Missing)
 
1154
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 11790 59.0%
 
ATE R$ 81.000,00 4370 21.9%
 
DE R$ 360.000,01 A R$ 1.500.000,00 2000 10.0%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 432 2.2%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 87 0.4%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 85 0.4%
 
SEM INFORMACAO 39 0.2%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 28 0.1%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 11 0.1%
 
ACIMA DE 1 BILHAO DE REAIS 2 < 0.1%
 
(Missing) 1154 5.8%
 
Max length40
Mean length26.554
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count12
Unique (%)0.1%
Missing (%)5.8%
Missing (n)1154
DE R$ 81.000,01 A R$ 360.000,00
10944
ATE R$ 81.000,00
4343
DE R$ 360.000,01 A R$ 1.500.000,00
2307
Other values (8)
 
1252
(Missing)
 
1154
ValueCountFrequency (%) 
DE R$ 81.000,01 A R$ 360.000,00 10944 54.7%
 
ATE R$ 81.000,00 4343 21.7%
 
DE R$ 360.000,01 A R$ 1.500.000,00 2307 11.5%
 
DE R$ 1.500.000,01 A R$ 4.800.000,00 562 2.8%
 
DE R$ 4.800.000,01 A R$ 10.000.000,00 179 0.9%
 
DE R$ 10.000.000,01 A R$ 30.000.000,00 148 0.7%
 
ACIMA DE 1 BILHAO DE REAIS 137 0.7%
 
DE R$ 30.000.000,01 A R$ 100.000.000,00 117 0.6%
 
DE R$ 100.000.000,01 A R$ 300.000.000,00 62 0.3%
 
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS 33 0.2%
 
(Missing) 1154 5.8%
 
Max length40
Mean length26.781
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_indicador_telefone
Constant

This variable is constant and should be ignored for analysis

Constant valueBOA

de_natureza_juridica
Categorical

Distinct count45
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
EMPRESARIO INDIVIDUAL
12904
SOCIEDADE EMPRESARIA LIMITADA
3885
ASSOCIACAO PRIVADA
 
1314
Other values (42)
 
1897
ValueCountFrequency (%) 
EMPRESARIO INDIVIDUAL 12904 64.5%
 
SOCIEDADE EMPRESARIA LIMITADA 3885 19.4%
 
ASSOCIACAO PRIVADA 1314 6.6%
 
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA 656 3.3%
 
ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO 313 1.6%
 
ORGANIZACAO RELIGIOSA 104 0.5%
 
CONDOMINIO EDILICIO 95 0.5%
 
CANDIDATO A CARGO POLITICO ELETIVO 80 0.4%
 
ENTIDADE SINDICAL 76 0.4%
 
SOCIEDADE ANONIMA FECHADA 68 0.3%
 
Other values (35) 505 2.5%
 
Max length70
Mean length24.474
Min length9
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_nivel_atividade
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)2.2%
Missing (n)448
MEDIA
9375
ALTA
6593
BAIXA
3404
(Missing)
 
448
ValueCountFrequency (%) 
MEDIA 9375 46.9%
 
ALTA 6593 33.0%
 
BAIXA 3404 17.0%
 
MUITO BAIXA 180 0.9%
 
(Missing) 448 2.2%
 
Max length11
Mean length4.6795
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_ramo
Categorical

Distinct count33
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
COMERCIO VAREJISTA
7492
SERVICOS DIVERSOS
2595
SERVICOS DE ALOJAMENTO/ALIMENTACAO
 
1316
Other values (30)
8597
ValueCountFrequency (%) 
COMERCIO VAREJISTA 7492 37.5%
 
SERVICOS DIVERSOS 2595 13.0%
 
SERVICOS DE ALOJAMENTO/ALIMENTACAO 1316 6.6%
 
INDUSTRIA DA CONSTRUCAO 1132 5.7%
 
COMERCIO E REPARACAO DE VEICULOS 962 4.8%
 
SERVICOS ADMINISTRATIVOS 937 4.7%
 
BENS DE CONSUMO 913 4.6%
 
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS 784 3.9%
 
COMERCIO POR ATACADO 692 3.5%
 
TRANSPORTE, ARMAZENAGEM E CORREIO 666 3.3%
 
Other values (23) 2511 12.6%
 
Max length49
Mean length22.115
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

de_saude_rescencia
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)3.0%
Missing (n)608
ACIMA DE 1 ANO
16430
ATE 1 ANO
 
1665
SEM INFORMACAO
 
1297
(Missing)
 
608
ValueCountFrequency (%) 
ACIMA DE 1 ANO 16430 82.2%
 
ATE 1 ANO 1665 8.3%
 
SEM INFORMACAO 1297 6.5%
 
(Missing) 608 3.0%
 
Max length14
Mean length13.249
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

de_saude_tributaria
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)3.0%
Missing (n)608
VERDE
6379
AZUL
4481
AMARELO
3951
Other values (3)
4581
ValueCountFrequency (%) 
VERDE 6379 31.9%
 
AZUL 4481 22.4%
 
AMARELO 3951 19.8%
 
CINZA 2772 13.9%
 
LARANJA 1579 7.9%
 
VERMELHO 230 1.1%
 
(Missing) 608 3.0%
 
Max length8
Mean length5.3026
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

dt_situacao
Categorical

Distinct count4215
Unique (%)21.1%
Missing (%)0.0%
Missing (n)0
2005-11-03
 
2995
2006-12-21
 
102
2006-12-01
 
80
Other values (4212)
16823
ValueCountFrequency (%) 
2005-11-03 2995 15.0%
 
2006-12-21 102 0.5%
 
2006-12-01 80 0.4%
 
2005-08-27 77 0.4%
 
2005-09-24 68 0.3%
 
1998-07-28 67 0.3%
 
2010-05-15 65 0.3%
 
2006-12-02 51 0.3%
 
2004-10-30 43 0.2%
 
2004-10-16 36 0.2%
 
Other values (4205) 16416 82.1%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count6857
Unique (%)34.3%
Missing (%)31.3%
Missing (n)6268
Infinite (%)0.0%
Infinite (n)0
Mean1302.2
Minimum110.3
Maximum30862
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum110.3
5-th percentile422.84
Q1668.88
Median946.33
Q31500
95-th percentile3475
Maximum30862
Range30752
Interquartile range831.12

Descriptive statistics

Standard deviation1112.4
Coef of variation0.85419
Kurtosis51.235
Mean1302.2
MAD715.32
Skewness4.2975
Sum1.7882e+07
Variance1.2374e+06
Memory size312.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1549.1 101 0.5%
 
2361.4 39 0.2%
 
1086 33 0.2%
 
3072 31 0.2%
 
3940.1 28 0.1%
 
786.74 23 0.1%
 
2019.4 22 0.1%
 
1699.2 19 0.1%
 
1910.8 19 0.1%
 
2679.5 18 0.1%
 
Other values (6846) 13399 67.0%
 
(Missing) 6268 31.3%
 

Minimum 5 values

ValueCountFrequency (%) 
110.3 1 < 0.1%
 
169.28 2 < 0.1%
 
180 1 < 0.1%
 
182.94 2 < 0.1%
 
183.71 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
30862 1 < 0.1%
 
13793 3 < 0.1%
 
12513 5 < 0.1%
 
10469 4 < 0.1%
 
10039 7 < 0.1%
 

faturamento_est_coligados
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.91204

faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis

Correlation0.99793

fl_antt
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)74
False
19793
True
 
133
(Missing)
 
74
ValueCountFrequency (%) 
False 19793 99.0%
 
True 133 0.7%
 
(Missing) 74 0.4%
 

fl_email
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
11044
True
8956
ValueCountFrequency (%) 
False 11044 55.2%
 
True 8956 44.8%
 

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant valueFalse

fl_ltda
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
19948
True
 
52
ValueCountFrequency (%) 
False 19948 99.7%
 
True 52 0.3%
 

fl_matriz
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
True
18843
False
 
1157
ValueCountFrequency (%) 
True 18843 94.2%
 
False 1157 5.8%
 

fl_me
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
19946
True
 
54
ValueCountFrequency (%) 
False 19946 99.7%
 
True 54 0.3%
 

fl_mei
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
13405
True
6595
ValueCountFrequency (%) 
False 13405 67.0%
 
True 6595 33.0%
 

fl_optante_simei
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)17.7%
Missing (n)3538
False
12291
True
4171
(Missing)
3538
ValueCountFrequency (%) 
False 12291 61.5%
 
True 4171 20.9%
 
(Missing) 3538 17.7%
 

fl_optante_simples
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)17.7%
Missing (n)3538
True
8843
False
7619
(Missing)
3538
ValueCountFrequency (%) 
True 8843 44.2%
 
False 7619 38.1%
 
(Missing) 3538 17.7%
 

fl_passivel_iss
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)74
True
11477
False
8449
(Missing)
 
74
ValueCountFrequency (%) 
True 11477 57.4%
 
False 8449 42.2%
 
(Missing) 74 0.4%
 

fl_rm
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
NAO
10288
SIM
9712
ValueCountFrequency (%) 
NAO 10288 51.4%
 
SIM 9712 48.6%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

fl_sa
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
19667
True
 
333
ValueCountFrequency (%) 
False 19667 98.3%
 
True 333 1.7%
 

fl_simples_irregular
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)74
False
19908
True
 
18
(Missing)
 
74
ValueCountFrequency (%) 
False 19908 99.5%
 
True 18 0.1%
 
(Missing) 74 0.4%
 

fl_spa
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)74
False
19916
True
 
10
(Missing)
 
74
ValueCountFrequency (%) 
False 19916 99.6%
 
True 10 0.1%
 
(Missing) 74 0.4%
 

fl_st_especial
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
19994
True
 
6
ValueCountFrequency (%) 
False 19994 > 99.9%
 
True 6 < 0.1%
 

fl_telefone
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
True
14602
False
5398
ValueCountFrequency (%) 
True 14602 73.0%
 
False 5398 27.0%
 

fl_veiculo
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)74
False
18607
True
 
1319
(Missing)
 
74
ValueCountFrequency (%) 
False 18607 93.0%
 
True 1319 6.6%
 
(Missing) 74 0.4%
 

grau_instrucao_macro_analfabeto
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)99.7%
Missing (n)19930
Infinite (%)0.0%
Infinite (n)0
Mean2.4571
Minimum1
Maximum41
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile7.55
Maximum41
Range40
Interquartile range1

Descriptive statistics

Standard deviation5.2022
Coef of variation2.1172
Kurtosis45.098
Mean2.4571
MAD2.1135
Skewness6.3353
Sum172
Variance27.063
Memory size312.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 47 0.2%
 
2 12 0.1%
 
3 5 < 0.1%
 
7 1 < 0.1%
 
14 1 < 0.1%
 
41 1 < 0.1%
 
12 1 < 0.1%
 
8 1 < 0.1%
 
4 1 < 0.1%
 
(Missing) 19930 99.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 47 0.2%
 
2 12 0.1%
 
3 5 < 0.1%
 
4 1 < 0.1%
 
7 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
41 1 < 0.1%
 
14 1 < 0.1%
 
12 1 < 0.1%
 
8 1 < 0.1%
 
7 1 < 0.1%
 

grau_instrucao_macro_desconhecido
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

grau_instrucao_macro_escolaridade_fundamental
Numeric

Distinct count68
Unique (%)0.3%
Missing (%)94.5%
Missing (n)18909
Infinite (%)0.0%
Infinite (n)0
Mean8.4308
Minimum1
Maximum971
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34
95-th percentile23.5
Maximum971
Range970
Interquartile range3

Descriptive statistics

Standard deviation43.108
Coef of variation5.1131
Kurtosis279.31
Mean8.4308
MAD11.054
Skewness15.003
Sum9198
Variance1858.3
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 511 2.6%
 
2 180 0.9%
 
3 104 0.5%
 
4 63 0.3%
 
5 36 0.2%
 
6 28 0.1%
 
7 24 0.1%
 
8 13 0.1%
 
11 10 0.1%
 
10 10 0.1%
 
Other values (57) 112 0.6%
 
(Missing) 18909 94.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 511 2.6%
 
2 180 0.9%
 
3 104 0.5%
 
4 63 0.3%
 
5 36 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
971 1 < 0.1%
 
586 1 < 0.1%
 
471 1 < 0.1%
 
437 1 < 0.1%
 
233 1 < 0.1%
 

grau_instrucao_macro_escolaridade_media
Numeric

Distinct count108
Unique (%)0.5%
Missing (%)85.3%
Missing (n)17060
Infinite (%)0.0%
Infinite (n)0
Mean10.011
Minimum1
Maximum2387
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median3
Q36
95-th percentile28
Maximum2387
Range2386
Interquartile range5

Descriptive statistics

Standard deviation61.126
Coef of variation6.1058
Kurtosis966.51
Mean10.011
MAD11.908
Skewness27.975
Sum29433
Variance3736.4
Memory size312.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 932 4.7%
 
2 487 2.4%
 
3 308 1.5%
 
4 215 1.1%
 
5 148 0.7%
 
6 119 0.6%
 
7 110 0.5%
 
8 69 0.3%
 
9 63 0.3%
 
10 49 0.2%
 
Other values (97) 440 2.2%
 
(Missing) 17060 85.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 932 4.7%
 
2 487 2.4%
 
3 308 1.5%
 
4 215 1.1%
 
5 148 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
2387 1 < 0.1%
 
1662 1 < 0.1%
 
523 1 < 0.1%
 
473 1 < 0.1%
 
471 1 < 0.1%
 

grau_instrucao_macro_escolaridade_superior
Numeric

Distinct count71
Unique (%)0.4%
Missing (%)95.3%
Missing (n)19058
Infinite (%)0.0%
Infinite (n)0
Mean16.412
Minimum1
Maximum2652
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34
95-th percentile32.9
Maximum2652
Range2651
Interquartile range3

Descriptive statistics

Standard deviation128.7
Coef of variation7.8419
Kurtosis268.31
Mean16.412
MAD25.271
Skewness15.476
Sum15460
Variance16564
Memory size312.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 468 2.3%
 
2 155 0.8%
 
3 71 0.4%
 
4 46 0.2%
 
6 25 0.1%
 
5 19 0.1%
 
7 15 0.1%
 
9 12 0.1%
 
8 11 0.1%
 
12 8 < 0.1%
 
Other values (60) 112 0.6%
 
(Missing) 19058 95.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 468 2.3%
 
2 155 0.8%
 
3 71 0.4%
 
4 46 0.2%
 
5 19 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2652 1 < 0.1%
 
1820 1 < 0.1%
 
1794 1 < 0.1%
 
836 1 < 0.1%
 
624 1 < 0.1%
 

id
Categorical, Unique

First 5 values
000771209cccfe8b7819f2b4268eed64e0bc791f42ac9b54fe8780bcdc3b1c59
00100f97371ee970819d79d123008a51a657bd953c9f5f10a8d6bf2a76cc16cb
00123b6e449556823ba4aac6dbb35b44f60557c511566f838dc889b75c6f9af1
0013cb64d383b0a8279866a69d4145500ae3e20fd848c90f6f828db4c72cc0f4
001555421ec37ae3440e5a070cc78f36f74146df2d4b1989c80f4ea404cbd028
Last 5 values
ffec2f6b21fff2a8379e133339634e6a39240dc55c956c17d1c03bb203141966
ffed1e47eaf7b3444605cd7cb91bf9ef7cf3bbe9f7f73092c10d21a1d454d1fd
fff06822a7e843723dbe870e65ac0a447082fb467a657e13f466c2cf4c9bfef9
fff5a3249f08ad99ffd8b13f3f29c366619b06c9d479c5a9e5115277b83ec11a
fff5af950eefc667f4b9648f497eae11b53b92ecbe5e508724373e5f8f2eec34

First 5 values

ValueCountFrequency (%) 
000771209cccfe8b7819f2b4268eed64e0bc791f42ac9b54fe8780bcdc3b1c59 1 < 0.1%
 
00100f97371ee970819d79d123008a51a657bd953c9f5f10a8d6bf2a76cc16cb 1 < 0.1%
 
00123b6e449556823ba4aac6dbb35b44f60557c511566f838dc889b75c6f9af1 1 < 0.1%
 
0013cb64d383b0a8279866a69d4145500ae3e20fd848c90f6f828db4c72cc0f4 1 < 0.1%
 
001555421ec37ae3440e5a070cc78f36f74146df2d4b1989c80f4ea404cbd028 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
fff5af950eefc667f4b9648f497eae11b53b92ecbe5e508724373e5f8f2eec34 1 < 0.1%
 
fff5a3249f08ad99ffd8b13f3f29c366619b06c9d479c5a9e5115277b83ec11a 1 < 0.1%
 
fff06822a7e843723dbe870e65ac0a447082fb467a657e13f466c2cf4c9bfef9 1 < 0.1%
 
ffed1e47eaf7b3444605cd7cb91bf9ef7cf3bbe9f7f73092c10d21a1d454d1fd 1 < 0.1%
 
ffec2f6b21fff2a8379e133339634e6a39240dc55c956c17d1c03bb203141966 1 < 0.1%
 

idade_acima_de_58
Numeric

Distinct count34
Unique (%)0.2%
Missing (%)97.6%
Missing (n)19524
Infinite (%)0.0%
Infinite (n)0
Mean11.931
Minimum1
Maximum1844
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile18
Maximum1844
Range1843
Interquartile range1

Descriptive statistics

Standard deviation107.42
Coef of variation9.0033
Kurtosis237.1
Mean11.931
MAD18.993
Skewness15.1
Sum5679
Variance11538
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 295 1.5%
 
2 79 0.4%
 
3 31 0.2%
 
4 12 0.1%
 
6 10 0.1%
 
5 8 < 0.1%
 
8 4 < 0.1%
 
18 4 < 0.1%
 
24 3 < 0.1%
 
45 3 < 0.1%
 
Other values (23) 27 0.1%
 
(Missing) 19524 97.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 295 1.5%
 
2 79 0.4%
 
3 31 0.2%
 
4 12 0.1%
 
5 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1844 1 < 0.1%
 
1401 1 < 0.1%
 
216 1 < 0.1%
 
212 1 < 0.1%
 
143 1 < 0.1%
 

idade_ate_18
Numeric

Distinct count8
Unique (%)< 0.1%
Missing (%)99.4%
Missing (n)19888
Infinite (%)0.0%
Infinite (n)0
Mean1.6964
Minimum1
Maximum8
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile5.45
Maximum8
Range7
Interquartile range1

Descriptive statistics

Standard deviation1.4694
Coef of variation0.8662
Kurtosis6.8426
Mean1.6964
MAD0.9949
Skewness2.6233
Sum190
Variance2.1593
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%) 
1 80 0.4%
 
2 14 0.1%
 
3 8 < 0.1%
 
6 4 < 0.1%
 
5 2 < 0.1%
 
8 2 < 0.1%
 
4 2 < 0.1%
 
(Missing) 19888 99.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 80 0.4%
 
2 14 0.1%
 
3 8 < 0.1%
 
4 2 < 0.1%
 
5 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8 2 < 0.1%
 
6 4 < 0.1%
 
5 2 < 0.1%
 
4 2 < 0.1%
 
3 8 < 0.1%
 

idade_de_19_a_23
Numeric

Distinct count29
Unique (%)0.1%
Missing (%)94.3%
Missing (n)18870
Infinite (%)0.0%
Infinite (n)0
Mean2.8584
Minimum1
Maximum50
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q33
95-th percentile9
Maximum50
Range49
Interquartile range2

Descriptive statistics

Standard deviation4.5512
Coef of variation1.5922
Kurtosis39.138
Mean2.8584
MAD2.2592
Skewness5.5398
Sum3230
Variance20.713
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 576 2.9%
 
2 240 1.2%
 
3 108 0.5%
 
4 51 0.3%
 
5 45 0.2%
 
6 19 0.1%
 
7 19 0.1%
 
9 12 0.1%
 
8 11 0.1%
 
10 9 < 0.1%
 
Other values (18) 40 0.2%
 
(Missing) 18870 94.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 576 2.9%
 
2 240 1.2%
 
3 108 0.5%
 
4 51 0.3%
 
5 45 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
50 1 < 0.1%
 
49 1 < 0.1%
 
43 1 < 0.1%
 
36 1 < 0.1%
 
34 2 < 0.1%
 

idade_de_24_a_28
Numeric

Distinct count51
Unique (%)0.3%
Missing (%)91.8%
Missing (n)18368
Infinite (%)0.0%
Infinite (n)0
Mean3.8444
Minimum1
Maximum144
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33
95-th percentile12
Maximum144
Range143
Interquartile range2

Descriptive statistics

Standard deviation9.001
Coef of variation2.3414
Kurtosis108.48
Mean3.8444
MAD3.5915
Skewness9.0596
Sum6274
Variance81.018
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 783 3.9%
 
2 305 1.5%
 
3 167 0.8%
 
4 88 0.4%
 
5 59 0.3%
 
6 42 0.2%
 
8 29 0.1%
 
7 28 0.1%
 
9 18 0.1%
 
10 15 0.1%
 
Other values (40) 98 0.5%
 
(Missing) 18368 91.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 783 3.9%
 
2 305 1.5%
 
3 167 0.8%
 
4 88 0.4%
 
5 59 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
144 1 < 0.1%
 
133 1 < 0.1%
 
128 1 < 0.1%
 
110 1 < 0.1%
 
90 1 < 0.1%
 

idade_de_29_a_33
Numeric

Distinct count59
Unique (%)0.3%
Missing (%)91.5%
Missing (n)18292
Infinite (%)0.0%
Infinite (n)0
Mean4.9327
Minimum1
Maximum411
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34
95-th percentile15
Maximum411
Range410
Interquartile range3

Descriptive statistics

Standard deviation18.928
Coef of variation3.8373
Kurtosis268.81
Mean4.9327
MAD5.2876
Skewness14.618
Sum8425
Variance358.27
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 832 4.2%
 
2 293 1.5%
 
3 154 0.8%
 
4 93 0.5%
 
5 80 0.4%
 
8 37 0.2%
 
6 34 0.2%
 
7 32 0.2%
 
9 21 0.1%
 
10 11 0.1%
 
Other values (48) 121 0.6%
 
(Missing) 18292 91.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 832 4.2%
 
2 293 1.5%
 
3 154 0.8%
 
4 93 0.5%
 
5 80 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
411 1 < 0.1%
 
405 1 < 0.1%
 
222 1 < 0.1%
 
213 1 < 0.1%
 
182 1 < 0.1%
 

idade_de_34_a_38
Highly correlated

This variable is highly correlated with idade_de_29_a_33 and should be ignored for analysis

Correlation0.96376

idade_de_39_a_43
Highly correlated

This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis

Correlation0.95304

idade_de_44_a_48
Highly correlated

This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis

Correlation0.92955

idade_de_49_a_53
Highly correlated

This variable is highly correlated with idade_de_44_a_48 and should be ignored for analysis

Correlation0.9679

idade_de_54_a_58
Highly correlated

This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis

Correlation0.94691

idade_emp_cat
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1 a 5
6103
5 a 10
5043
> 20
3261
Other values (3)
5593
ValueCountFrequency (%) 
1 a 5 6103 30.5%
 
5 a 10 5043 25.2%
 
> 20 3261 16.3%
 
10 a 15 2045 10.2%
 
<= 1 1982 9.9%
 
15 a 20 1566 7.8%
 
Max length7
Mean length5.3511
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

idade_empresa_anos
Numeric

Distinct count6971
Unique (%)34.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean9.8907
Minimum0.027397
Maximum55.833
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.027397
5-th percentile0.48767
Q12.7315
Median6.6301
Q314.43
95-th percentile29.875
Maximum55.833
Range55.805
Interquartile range11.699

Descriptive statistics

Standard deviation9.5795
Coef of variation0.96854
Kurtosis1.4746
Mean9.8907
MAD7.5309
Skewness1.375
Sum1.9781e+05
Variance91.767
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[2.73972603e-02 2.01369863e-01 2.09589041e-01 7.41095890e-01 7.46575342e-01 ... 3.90753425e+01 4.38479452e+01 4.38753425e+01 5.26095890e+01 5.58328767e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.20822 28 0.1%
 
0.20548 28 0.1%
 
0.74247 23 0.1%
 
8.0219 18 0.1%
 
0.24384 17 0.1%
 
0.21644 17 0.1%
 
0.20274 17 0.1%
 
0.65753 16 0.1%
 
0.45753 16 0.1%
 
0.55068 15 0.1%
 
Other values (6961) 19805 99.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0.027397 2 < 0.1%
 
0.030137 8 < 0.1%
 
0.032877 8 < 0.1%
 
0.035616 3 < 0.1%
 
0.038356 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
55.833 1 < 0.1%
 
52.942 1 < 0.1%
 
52.277 2 < 0.1%
 
52.236 1 < 0.1%
 
52.2 1 < 0.1%
 

idade_maxima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.94271

idade_maxima_socios
Numeric

Distinct count88
Unique (%)0.4%
Missing (%)32.9%
Missing (n)6586
Infinite (%)0.0%
Infinite (n)0
Mean44.23
Minimum8
Maximum118
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum8
5-th percentile24
Q134
Median43
Q354
95-th percentile69
Maximum118
Range110
Interquartile range20

Descriptive statistics

Standard deviation13.935
Coef of variation0.31505
Kurtosis0.040116
Mean44.23
MAD11.338
Skewness0.55591
Sum5.9330e+05
Variance194.18
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
37 413 2.1%
 
36 386 1.9%
 
35 385 1.9%
 
41 385 1.9%
 
39 377 1.9%
 
40 372 1.9%
 
44 370 1.8%
 
33 362 1.8%
 
34 355 1.8%
 
38 344 1.7%
 
Other values (77) 9665 48.3%
 
(Missing) 6586 32.9%
 

Minimum 5 values

ValueCountFrequency (%) 
8 1 < 0.1%
 
13 1 < 0.1%
 
16 1 < 0.1%
 
17 1 < 0.1%
 
18 19 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
118 1 < 0.1%
 
110 1 < 0.1%
 
106 1 < 0.1%
 
104 2 < 0.1%
 
97 2 < 0.1%
 

idade_media_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.97597

idade_media_coligadas_ativas
Highly correlated

This variable is highly correlated with idade_media_coligadas and should be ignored for analysis

Correlation0.99868

idade_media_coligadas_baixadas
Highly correlated

This variable is highly correlated with idade_media_coligadas_ativas and should be ignored for analysis

Correlation0.92832

idade_media_socios
Highly correlated

This variable is highly correlated with idade_maxima_socios and should be ignored for analysis

Correlation0.95975

idade_minima_coligadas
Highly correlated

This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis

Correlation0.99882

idade_minima_socios
Highly correlated

This variable is highly correlated with idade_media_socios and should be ignored for analysis

Correlation0.95683

max_faturamento_est_coligados
Highly correlated

This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis

Correlation0.94776

max_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis

Correlation0.99411

max_filiais_coligados
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.97946

max_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.9016

max_meses_servicos
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation0.97658

max_meses_servicos_all
Numeric

Distinct count1619
Unique (%)8.1%
Missing (%)77.6%
Missing (n)15515
Infinite (%)0.0%
Infinite (n)0
Mean168.05
Minimum-0.63333
Maximum5099.1
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum-0.63333
5-th percentile5.9667
Q125.333
Median54.667
Q395.167
95-th percentile250.11
Maximum5099.1
Range5099.7
Interquartile range69.833

Descriptive statistics

Standard deviation682.64
Coef of variation4.0621
Kurtosis46.676
Mean168.05
MAD200.67
Skewness6.9344
Sum7.537e+05
Variance4.6599e+05
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
93.267 33 0.2%
 
5015 28 0.1%
 
67.867 27 0.1%
 
5064.7 26 0.1%
 
40.5 26 0.1%
 
63.8 25 0.1%
 
88.167 25 0.1%
 
92.233 24 0.1%
 
28.3 24 0.1%
 
33.333 23 0.1%
 
Other values (1608) 4224 21.1%
 
(Missing) 15515 77.6%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.63333 1 < 0.1%
 
-0.066667 1 < 0.1%
 
0 5 < 0.1%
 
0.13333 1 < 0.1%
 
0.23333 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 12 0.1%
 
5066.7 7 < 0.1%
 
5065.7 4 < 0.1%
 
5064.7 26 0.1%
 
5039.3 3 < 0.1%
 

max_vl_folha_coligados
Highly correlated

This variable is highly correlated with max_filiais_coligados and should be ignored for analysis

Correlation0.91799

max_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with max_vl_folha_coligados and should be ignored for analysis

Correlation0.9144

media_faturamento_est_coligados
Numeric

Distinct count962
Unique (%)4.8%
Missing (%)86.7%
Missing (n)17332
Infinite (%)0.0%
Infinite (n)0
Mean2.371e+07
Minimum41213
Maximum6.1297e+09
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum41213
5-th percentile1.6682e+05
Q12.1e+05
Median3.6103e+05
Q31.1127e+06
95-th percentile1.8733e+07
Maximum6.1297e+09
Range6.1297e+09
Interquartile range9.0275e+05

Descriptive statistics

Standard deviation2.3796e+08
Coef of variation10.036
Kurtosis421.67
Mean2.371e+07
MAD4.2864e+07
Skewness18.882
Sum6.3258e+10
Variance5.6625e+16
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 939 4.7%
 
9.3e+05 100 0.5%
 
3.7092e+05 46 0.2%
 
50000 44 0.2%
 
1.8546e+05 35 0.2%
 
5.7e+05 29 0.1%
 
1.2364e+05 26 0.1%
 
5.5637e+05 20 0.1%
 
7.4183e+05 20 0.1%
 
1.6682e+05 20 0.1%
 
Other values (951) 1389 6.9%
 
(Missing) 17332 86.7%
 

Minimum 5 values

ValueCountFrequency (%) 
41213 6 < 0.1%
 
50000 44 0.2%
 
51516 1 < 0.1%
 
61819 3 < 0.1%
 
82426 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6.1297e+09 1 < 0.1%
 
5.6516e+09 2 < 0.1%
 
3.4331e+09 1 < 0.1%
 
2.274e+09 1 < 0.1%
 
2.0492e+09 2 < 0.1%
 

media_faturamento_est_coligados_gp
Highly correlated

This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis

Correlation0.98196

media_filiais_coligados
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.98273

media_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.93916

media_meses_servicos
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation0.94844

media_meses_servicos_all
Numeric

Distinct count3801
Unique (%)19.0%
Missing (%)77.6%
Missing (n)15515
Infinite (%)0.0%
Infinite (n)0
Mean43.279
Minimum-0.63333
Maximum5099.1
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum-0.63333
5-th percentile4.6361
Q113.825
Median23.944
Q340.806
95-th percentile103.88
Maximum5099.1
Range5099.7
Interquartile range26.981

Descriptive statistics

Standard deviation158.25
Coef of variation3.6564
Kurtosis695.6
Mean43.279
MAD35.851
Skewness23.838
Sum1.9411e+05
Variance25041
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.9333 15 0.1%
 
11.133 12 0.1%
 
1 11 0.1%
 
5.1 11 0.1%
 
4.0667 11 0.1%
 
14.2 10 0.1%
 
8.0333 10 0.1%
 
2.0333 10 0.1%
 
39.467 9 < 0.1%
 
8.9667 9 < 0.1%
 
Other values (3790) 4377 21.9%
 
(Missing) 15515 77.6%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.63333 1 < 0.1%
 
-0.066667 1 < 0.1%
 
0 5 < 0.1%
 
0.13333 1 < 0.1%
 
0.23333 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 1 < 0.1%
 
5015 2 < 0.1%
 
2539.9 1 < 0.1%
 
1785.9 1 < 0.1%
 
1734.3 1 < 0.1%
 

media_vl_folha_coligados
Numeric

Distinct count695
Unique (%)3.5%
Missing (%)92.4%
Missing (n)18485
Infinite (%)0.0%
Infinite (n)0
Mean5.3355e+06
Minimum0
Maximum5.2296e+08
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile61819
Q11.8546e+05
Median4.7689e+05
Q31.6691e+06
95-th percentile1.9745e+07
Maximum5.2296e+08
Range5.2296e+08
Interquartile range1.4837e+06

Descriptive statistics

Standard deviation2.4588e+07
Coef of variation4.6084
Kurtosis175.47
Mean5.3355e+06
MAD7.9618e+06
Skewness11.237
Sum8.0833e+09
Variance6.0458e+14
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 126 0.6%
 
1.2364e+05 73 0.4%
 
1.8546e+05 61 0.3%
 
2.4728e+05 37 0.2%
 
20606 34 0.2%
 
3.091e+05 29 0.1%
 
4.3273e+05 27 0.1%
 
3.7092e+05 22 0.1%
 
4.9455e+05 21 0.1%
 
2.0606e+05 21 0.1%
 
Other values (684) 1064 5.3%
 
(Missing) 18485 92.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4 < 0.1%
 
10303 1 < 0.1%
 
20606 34 0.2%
 
27475 1 < 0.1%
 
30910 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5.2296e+08 1 < 0.1%
 
3.4343e+08 1 < 0.1%
 
2.6754e+08 1 < 0.1%
 
2.2947e+08 1 < 0.1%
 
1.6782e+08 2 < 0.1%
 

media_vl_folha_coligados_gp
Numeric

Distinct count714
Unique (%)3.6%
Missing (%)92.4%
Missing (n)18477
Infinite (%)0.0%
Infinite (n)0
Mean1.2033e+07
Minimum0
Maximum1.3928e+09
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile61819
Q11.8546e+05
Median5.2546e+05
Q32.1551e+06
95-th percentile4.5519e+07
Maximum1.3928e+09
Range1.3928e+09
Interquartile range1.9696e+06

Descriptive statistics

Standard deviation7.3986e+07
Coef of variation6.1485
Kurtosis206.6
Mean1.2033e+07
MAD1.9443e+07
Skewness13.187
Sum1.8326e+10
Variance5.4739e+15
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 127 0.6%
 
1.2364e+05 69 0.3%
 
1.8546e+05 55 0.3%
 
2.4728e+05 39 0.2%
 
20606 32 0.2%
 
3.091e+05 27 0.1%
 
4.3273e+05 26 0.1%
 
4.9455e+05 23 0.1%
 
3.7092e+05 23 0.1%
 
2.0606e+05 21 0.1%
 
Other values (703) 1081 5.4%
 
(Missing) 18477 92.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 4 < 0.1%
 
10303 1 < 0.1%
 
20606 32 0.2%
 
27475 1 < 0.1%
 
41213 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.3928e+09 1 < 0.1%
 
1.3424e+09 1 < 0.1%
 
1.1771e+09 1 < 0.1%
 
7.3495e+08 1 < 0.1%
 
6.6447e+08 1 < 0.1%
 

meses_ultima_contratacaco
Numeric

Distinct count1023
Unique (%)5.1%
Missing (%)77.6%
Missing (n)15515
Infinite (%)0.0%
Infinite (n)0
Mean44.159
Minimum1.9333
Maximum5099.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.9333
5-th percentile2.9333
Q18.9667
Median30.333
Q359.733
95-th percentile108.43
Maximum5099.1
Range5097.1
Interquartile range50.767

Descriptive statistics

Standard deviation136.51
Coef of variation3.0914
Kurtosis1256.6
Mean44.159
MAD33.711
Skewness34.023
Sum1.9805e+05
Variance18635
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.9333 128 0.6%
 
8.0333 75 0.4%
 
5.9667 73 0.4%
 
3.9333 71 0.4%
 
4.9667 67 0.3%
 
8.9667 51 0.3%
 
14.067 51 0.3%
 
24.2 50 0.2%
 
15.1 49 0.2%
 
26.233 45 0.2%
 
Other values (1012) 3825 19.1%
 
(Missing) 15515 77.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1.9333 1 < 0.1%
 
1.9667 2 < 0.1%
 
2 5 < 0.1%
 
2.0333 5 < 0.1%
 
2.0667 9 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 3 < 0.1%
 
332.7 1 < 0.1%
 
325.53 1 < 0.1%
 
321 1 < 0.1%
 
307 1 < 0.1%
 

min_faturamento_est_coligados
Numeric

Distinct count171
Unique (%)0.9%
Missing (%)86.7%
Missing (n)17332
Infinite (%)0.0%
Infinite (n)0
Mean7.8437e+05
Minimum0
Maximum2.6072e+08
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile50000
Q12.1e+05
Median2.1e+05
Q32.1e+05
95-th percentile1.4837e+06
Maximum2.6072e+08
Range2.6072e+08
Interquartile range0

Descriptive statistics

Standard deviation6.4999e+06
Coef of variation8.2868
Kurtosis1062.1
Mean7.8437e+05
MAD9.8931e+05
Skewness29.558
Sum2.0927e+09
Variance4.2249e+13
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 1549 7.7%
 
1.2364e+05 163 0.8%
 
9.3e+05 113 0.6%
 
1.8546e+05 105 0.5%
 
3.7092e+05 64 0.3%
 
41213 55 0.3%
 
50000 50 0.2%
 
2.4728e+05 40 0.2%
 
2.0606e+05 32 0.2%
 
5.5637e+05 30 0.1%
 
Other values (160) 467 2.3%
 
(Missing) 17332 86.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 10 0.1%
 
900 1 < 0.1%
 
1899.1 1 < 0.1%
 
3832.9 1 < 0.1%
 
6000 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.6072e+08 1 < 0.1%
 
1.4589e+08 1 < 0.1%
 
6.1253e+07 2 < 0.1%
 
4.9301e+07 1 < 0.1%
 
4.7704e+07 1 < 0.1%
 

min_faturamento_est_coligados_gp
Numeric

Distinct count234
Unique (%)1.2%
Missing (%)86.7%
Missing (n)17332
Infinite (%)0.0%
Infinite (n)0
Mean1.265e+06
Minimum900
Maximum8.1945e+08
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum900
5-th percentile82426
Q12.1e+05
Median2.1e+05
Q33.091e+05
95-th percentile2.0328e+06
Maximum8.1945e+08
Range8.1945e+08
Interquartile range99096

Descriptive statistics

Standard deviation1.7359e+07
Coef of variation13.722
Kurtosis1872.9
Mean1.265e+06
MAD1.805e+06
Skewness40.941
Sum3.3751e+09
Variance3.0133e+14
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 1498 7.5%
 
1.2364e+05 156 0.8%
 
9.3e+05 104 0.5%
 
1.8546e+05 90 0.4%
 
3.7092e+05 53 0.3%
 
50000 51 0.3%
 
4.2e+05 46 0.2%
 
41213 44 0.2%
 
2.4728e+05 38 0.2%
 
5.5637e+05 24 0.1%
 
Other values (223) 564 2.8%
 
(Missing) 17332 86.7%
 

Minimum 5 values

ValueCountFrequency (%) 
900 1 < 0.1%
 
3832.9 1 < 0.1%
 
6000 1 < 0.1%
 
12129 1 < 0.1%
 
19079 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8.1945e+08 1 < 0.1%
 
2.6072e+08 1 < 0.1%
 
1.4589e+08 1 < 0.1%
 
8.1346e+07 2 < 0.1%
 
7.2741e+07 1 < 0.1%
 

min_filiais_coligados
Numeric

Distinct count29
Unique (%)0.1%
Missing (%)96.0%
Missing (n)19201
Infinite (%)0.0%
Infinite (n)0
Mean3.1952
Minimum1
Maximum314
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile7
Maximum314
Range313
Interquartile range1

Descriptive statistics

Standard deviation13.58
Coef of variation4.25
Kurtosis357.82
Mean3.1952
MAD3.3214
Skewness17.007
Sum2553
Variance184.41
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 548 2.7%
 
2 95 0.5%
 
3 53 0.3%
 
4 39 0.2%
 
5 11 0.1%
 
6 11 0.1%
 
23 5 < 0.1%
 
7 4 < 0.1%
 
44 3 < 0.1%
 
15 3 < 0.1%
 
Other values (18) 27 0.1%
 
(Missing) 19201 96.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1 548 2.7%
 
2 95 0.5%
 
3 53 0.3%
 
4 39 0.2%
 
5 11 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
314 1 < 0.1%
 
126 1 < 0.1%
 
106 1 < 0.1%
 
67 2 < 0.1%
 
48 1 < 0.1%
 

min_funcionarios_coligados_gp
Numeric

Distinct count103
Unique (%)0.5%
Missing (%)91.3%
Missing (n)18262
Infinite (%)0.0%
Infinite (n)0
Mean25.666
Minimum0
Maximum10836
Zeros (%)2.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median2
Q36
95-th percentile42
Maximum10836
Range10836
Interquartile range6

Descriptive statistics

Standard deviation317.39
Coef of variation12.366
Kurtosis879.84
Mean25.666
MAD41.498
Skewness28.164
Sum44607
Variance1.0074e+05
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 577 2.9%
 
1 278 1.4%
 
2 161 0.8%
 
3 113 0.6%
 
4 75 0.4%
 
5 60 0.3%
 
6 54 0.3%
 
7 48 0.2%
 
8 42 0.2%
 
10 37 0.2%
 
Other values (92) 293 1.5%
 
(Missing) 18262 91.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 577 2.9%
 
1 278 1.4%
 
2 161 0.8%
 
3 113 0.6%
 
4 75 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
10836 1 < 0.1%
 
6548 1 < 0.1%
 
2451 1 < 0.1%
 
1340 1 < 0.1%
 
963 1 < 0.1%
 

min_meses_servicos
Numeric

Distinct count798
Unique (%)4.0%
Missing (%)83.5%
Missing (n)16703
Infinite (%)0.0%
Infinite (n)0
Mean37.116
Minimum1.9333
Maximum5099.1
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.9333
5-th percentile2.7667
Q16.9667
Median23.467
Q347.567
95-th percentile94.7
Maximum5099.1
Range5097.1
Interquartile range40.6

Descriptive statistics

Standard deviation130.34
Coef of variation3.5118
Kurtosis1379.9
Mean37.116
MAD30.588
Skewness35.627
Sum1.2237e+05
Variance16989
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.9333 124 0.6%
 
5.9667 71 0.4%
 
3.9333 70 0.4%
 
4.9667 66 0.3%
 
8.0333 64 0.3%
 
8.9667 50 0.2%
 
24.2 40 0.2%
 
28.3 40 0.2%
 
14.067 39 0.2%
 
6.9667 39 0.2%
 
Other values (787) 2694 13.5%
 
(Missing) 16703 83.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1.9333 1 < 0.1%
 
1.9667 2 < 0.1%
 
2 5 < 0.1%
 
2.0333 5 < 0.1%
 
2.0667 9 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
5099.1 2 < 0.1%
 
528.2 1 < 0.1%
 
302.57 1 < 0.1%
 
300.23 1 < 0.1%
 
291.07 1 < 0.1%
 

min_meses_servicos_all
Highly correlated

This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis

Correlation0.9754

min_vl_folha_coligados
Numeric

Distinct count168
Unique (%)0.8%
Missing (%)92.4%
Missing (n)18485
Infinite (%)0.0%
Infinite (n)0
Mean1.6461e+06
Minimum0
Maximum3.4343e+08
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile20606
Q161819
Median1.8546e+05
Q35.1516e+05
95-th percentile2.8911e+06
Maximum3.4343e+08
Range3.4343e+08
Interquartile range4.5334e+05

Descriptive statistics

Standard deviation1.2659e+07
Coef of variation7.6904
Kurtosis398.22
Mean1.6461e+06
MAD2.491e+06
Skewness17.742
Sum2.4938e+09
Variance1.6024e+14
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
61819 287 1.4%
 
1.2364e+05 156 0.8%
 
1.8546e+05 99 0.5%
 
20606 84 0.4%
 
2.4728e+05 59 0.3%
 
3.091e+05 45 0.2%
 
1.0303e+05 38 0.2%
 
4.3273e+05 34 0.2%
 
0 33 0.2%
 
3.7092e+05 32 0.2%
 
Other values (157) 648 3.2%
 
(Missing) 18485 92.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 33 0.2%
 
20606 84 0.4%
 
41213 28 0.1%
 
61819 287 1.4%
 
82426 28 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3.4343e+08 1 < 0.1%
 
1.5482e+08 1 < 0.1%
 
1.3491e+08 4 < 0.1%
 
6.0397e+07 5 < 0.1%
 
5.8357e+07 1 < 0.1%
 

min_vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with min_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.93663

natureza_juridica_macro
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
OUTROS
13960
ENTIDADES EMPRESARIAIS
4180
ENTIDADES SEM FINS LUCRATIVOS
 
1610
Other values (3)
 
250
ValueCountFrequency (%) 
OUTROS 13960 69.8%
 
ENTIDADES EMPRESARIAIS 4180 20.9%
 
ENTIDADES SEM FINS LUCRATIVOS 1610 8.1%
 
ADMINISTRACAO PUBLICA 120 0.6%
 
CARGO POLITICO 80 0.4%
 
PESSOAS FISICAS 50 0.2%
 
Max length29
Mean length11.34
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_divisao
Categorical

Distinct count86
Unique (%)0.4%
Missing (%)0.4%
Missing (n)74
COMERCIO VAREJISTA
7492
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS
 
1652
ALIMENTACAO
 
1209
Other values (82)
9573
ValueCountFrequency (%) 
COMERCIO VAREJISTA 7492 37.5%
 
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS 1652 8.3%
 
ALIMENTACAO 1209 6.0%
 
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 962 4.8%
 
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS 692 3.5%
 
OUTRAS ATIVIDADES DE SERVICOS PESSOAIS 658 3.3%
 
SERVICOS ESPECIALIZADOS PARA CONSTRUCAO 645 3.2%
 
TRANSPORTE TERRESTRE 492 2.5%
 
EDUCACAO 463 2.3%
 
SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS 431 2.2%
 
Other values (75) 5230 26.2%
 
Max length120
Mean length33.007
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_meso_regiao
Categorical

Distinct count20
Unique (%)0.1%
Missing (%)12.5%
Missing (n)2505
CENTRO AMAZONENSE
3098
NORTE MARANHENSE
2641
LESTE POTIGUAR
2557
Other values (16)
9199
(Missing)
2505
ValueCountFrequency (%) 
CENTRO AMAZONENSE 3098 15.5%
 
NORTE MARANHENSE 2641 13.2%
 
LESTE POTIGUAR 2557 12.8%
 
CENTRO NORTE PIAUIENSE 1824 9.1%
 
OESTE MARANHENSE 1119 5.6%
 
OESTE POTIGUAR 900 4.5%
 
LESTE MARANHENSE 816 4.1%
 
VALE DO ACRE 719 3.6%
 
CENTRO MARANHENSE 624 3.1%
 
SUDOESTE PIAUIENSE 514 2.6%
 
Other values (9) 2683 13.4%
 
(Missing) 2505 12.5%
 
Max length22
Mean length14.606
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_micro_regiao
Categorical

Distinct count74
Unique (%)0.4%
Missing (%)12.5%
Missing (n)2505
MANAUS
2622
NATAL
 
2038
AGLOMERACAO URBANA DE SAO LUIS
 
1980
Other values (70)
10855
(Missing)
2505
ValueCountFrequency (%) 
MANAUS 2622 13.1%
 
NATAL 2038 10.2%
 
AGLOMERACAO URBANA DE SAO LUIS 1980 9.9%
 
TERESINA 1443 7.2%
 
IMPERATRIZ 648 3.2%
 
RIO BRANCO 617 3.1%
 
MOSSORO 457 2.3%
 
PINDARE 348 1.7%
 
MACAIBA 316 1.6%
 
CAXIAS 314 1.6%
 
Other values (63) 6712 33.6%
 
(Missing) 2505 12.5%
 
Max length33
Mean length11.069
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nm_segmento
Categorical

Distinct count22
Unique (%)0.1%
Missing (%)0.4%
Missing (n)74
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS
9146
OUTRAS ATIVIDADES DE SERVICOS
2563
INDUSTRIAS DE TRANSFORMACAO
 
1343
Other values (18)
6874
ValueCountFrequency (%) 
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS 9146 45.7%
 
OUTRAS ATIVIDADES DE SERVICOS 2563 12.8%
 
INDUSTRIAS DE TRANSFORMACAO 1343 6.7%
 
ALOJAMENTO E ALIMENTACAO 1316 6.6%
 
CONSTRUCAO 1132 5.7%
 
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES 937 4.7%
 
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS 784 3.9%
 
TRANSPORTE ARMAZENAGEM E CORREIO 666 3.3%
 
EDUCACAO 463 2.3%
 
SAUDE HUMANA E SERVICOS SOCIAIS 451 2.3%
 
Other values (11) 1125 5.6%
 
Max length65
Mean length42.612
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

nu_meses_rescencia
Numeric

Distinct count39
Unique (%)0.2%
Missing (%)9.5%
Missing (n)1905
Infinite (%)0.0%
Infinite (n)0
Mean24.976
Minimum7
Maximum54
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile9
Q122
Median23
Q325
95-th percentile48
Maximum54
Range47
Interquartile range3

Descriptive statistics

Standard deviation9.651
Coef of variation0.38641
Kurtosis1.9685
Mean24.976
MAD5.8477
Skewness1.2694
Sum4.5195e+05
Variance93.142
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
23 4744 23.7%
 
22 3838 19.2%
 
24 1915 9.6%
 
48 1140 5.7%
 
25 1101 5.5%
 
26 1079 5.4%
 
27 811 4.1%
 
21 506 2.5%
 
7 415 2.1%
 
9 405 2.0%
 
Other values (28) 2141 10.7%
 
(Missing) 1905 9.5%
 

Minimum 5 values

ValueCountFrequency (%) 
7 415 2.1%
 
8 249 1.2%
 
9 405 2.0%
 
10 279 1.4%
 
11 199 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
54 75 0.4%
 
53 3 < 0.1%
 
52 39 0.2%
 
51 2 < 0.1%
 
50 296 1.5%
 

percent_func_genero_fem
Numeric

Distinct count314
Unique (%)1.6%
Missing (%)83.6%
Missing (n)16721
Infinite (%)0.0%
Infinite (n)0
Mean44.353
Minimum0
Maximum100
Zeros (%)4.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median40
Q384.675
95-th percentile100
Maximum100
Range100
Interquartile range84.675

Descriptive statistics

Standard deviation39.175
Coef of variation0.88325
Kurtosis-1.4666
Mean44.353
MAD34.873
Skewness0.25028
Sum1.4544e+05
Variance1534.7
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 961 4.8%
 
100 755 3.8%
 
50 281 1.4%
 
33.33 116 0.6%
 
25 102 0.5%
 
66.67 88 0.4%
 
75 54 0.3%
 
40 44 0.2%
 
20 42 0.2%
 
60 37 0.2%
 
Other values (303) 799 4.0%
 
(Missing) 16721 83.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 961 4.8%
 
0.89 1 < 0.1%
 
0.95 1 < 0.1%
 
1.19 1 < 0.1%
 
1.54 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 755 3.8%
 
94.44 2 < 0.1%
 
94.12 2 < 0.1%
 
93.75 2 < 0.1%
 
92.86 3 < 0.1%
 

percent_func_genero_masc
Numeric

Distinct count314
Unique (%)1.6%
Missing (%)83.6%
Missing (n)16721
Infinite (%)0.0%
Infinite (n)0
Mean55.647
Minimum0
Maximum100
Zeros (%)3.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q115.325
Median60
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range84.675

Descriptive statistics

Standard deviation39.175
Coef of variation0.704
Kurtosis-1.4666
Mean55.647
MAD34.873
Skewness-0.25028
Sum1.8246e+05
Variance1534.7
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
100 961 4.8%
 
0 755 3.8%
 
50 281 1.4%
 
66.67 116 0.6%
 
75 102 0.5%
 
33.33 88 0.4%
 
25 54 0.3%
 
60 44 0.2%
 
80 42 0.2%
 
40 37 0.2%
 
Other values (303) 799 4.0%
 
(Missing) 16721 83.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 755 3.8%
 
5.56 2 < 0.1%
 
5.88 2 < 0.1%
 
6.25 2 < 0.1%
 
7.14 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 961 4.8%
 
99.11 1 < 0.1%
 
99.05 1 < 0.1%
 
98.81 1 < 0.1%
 
98.46 1 < 0.1%
 

qt_admitidos
Numeric

Distinct count299
Unique (%)1.5%
Missing (%)77.6%
Missing (n)15515
Infinite (%)0.0%
Infinite (n)0
Mean43.8
Minimum1
Maximum12447
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median6
Q319
95-th percentile128.8
Maximum12447
Range12446
Interquartile range17

Descriptive statistics

Standard deviation322.41
Coef of variation7.3609
Kurtosis773.39
Mean43.8
MAD61.394
Skewness25.07
Sum1.9644e+05
Variance1.0395e+05
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 848 4.2%
 
2 470 2.4%
 
3 354 1.8%
 
4 259 1.3%
 
5 210 1.1%
 
6 168 0.8%
 
7 157 0.8%
 
8 135 0.7%
 
9 126 0.6%
 
10 92 0.5%
 
Other values (288) 1666 8.3%
 
(Missing) 15515 77.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 848 4.2%
 
2 470 2.4%
 
3 354 1.8%
 
4 259 1.3%
 
5 210 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
12447 1 < 0.1%
 
9208 1 < 0.1%
 
7849 1 < 0.1%
 
6169 1 < 0.1%
 
6103 1 < 0.1%
 

qt_admitidos_12meses
Numeric

Distinct count60
Unique (%)0.3%
Missing (%)77.6%
Missing (n)15515
Infinite (%)0.0%
Infinite (n)0
Mean1.8707
Minimum0
Maximum557
Zeros (%)16.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile7
Maximum557
Range557
Interquartile range1

Descriptive statistics

Standard deviation12.544
Coef of variation6.7056
Kurtosis1014.9
Mean1.8707
MAD2.8594
Skewness27.343
Sum8390
Variance157.35
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 3209 16.0%
 
1 470 2.4%
 
2 216 1.1%
 
3 127 0.6%
 
4 99 0.5%
 
5 59 0.3%
 
6 51 0.3%
 
7 32 0.2%
 
9 25 0.1%
 
8 23 0.1%
 
Other values (49) 174 0.9%
 
(Missing) 15515 77.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 3209 16.0%
 
1 470 2.4%
 
2 216 1.1%
 
3 127 0.6%
 
4 99 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
557 1 < 0.1%
 
331 1 < 0.1%
 
248 1 < 0.1%
 
163 1 < 0.1%
 
151 1 < 0.1%
 

qt_alteracao_socio_180d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_365d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_90d
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_alteracao_socio_total
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

qt_art
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation1

qt_coligadas
Numeric

Distinct count40
Unique (%)0.2%
Missing (%)89.4%
Missing (n)17889
Infinite (%)0.0%
Infinite (n)0
Mean2.8745
Minimum1
Maximum289
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q33
95-th percentile7
Maximum289
Range288
Interquartile range2

Descriptive statistics

Standard deviation9.2704
Coef of variation3.2251
Kurtosis524.71
Mean2.8745
MAD2.4248
Skewness20.236
Sum6068
Variance85.94
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 1176 5.9%
 
2 406 2.0%
 
3 193 1.0%
 
4 107 0.5%
 
5 60 0.3%
 
6 42 0.2%
 
7 28 0.1%
 
9 13 0.1%
 
8 12 0.1%
 
10 10 0.1%
 
Other values (29) 64 0.3%
 
(Missing) 17889 89.4%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1176 5.9%
 
2 406 2.0%
 
3 193 1.0%
 
4 107 0.5%
 
5 60 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
289 1 < 0.1%
 
163 1 < 0.1%
 
161 1 < 0.1%
 
118 1 < 0.1%
 
61 1 < 0.1%
 

qt_coligados
Highly correlated

This variable is highly correlated with qt_coligadas and should be ignored for analysis

Correlation0.99975

qt_coligados_agropecuaria
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean0.12731
Minimum0
Maximum9
Zeros (%)12.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9
Range9
Interquartile range0

Descriptive statistics

Standard deviation0.64445
Coef of variation5.0622
Kurtosis71.998
Mean0.12731
MAD0.23798
Skewness7.7178
Sum345
Variance0.41531
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2533 12.7%
 
1 107 0.5%
 
2 35 0.2%
 
3 13 0.1%
 
7 10 0.1%
 
4 7 < 0.1%
 
5 2 < 0.1%
 
6 2 < 0.1%
 
9 1 < 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2533 12.7%
 
1 107 0.5%
 
2 35 0.2%
 
3 13 0.1%
 
4 7 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9 1 < 0.1%
 
7 10 0.1%
 
6 2 < 0.1%
 
5 2 < 0.1%
 
4 7 < 0.1%
 

qt_coligados_atividade_alto
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_inativo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_medio
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_atividade_mt_baixo
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_ativo
Highly correlated

This variable is highly correlated with qt_coligados and should be ignored for analysis

Correlation0.99782

qt_coligados_baixada
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
0
 
2700
1
 
8
2
 
2
(Missing)
17290
ValueCountFrequency (%) 
0 2700 13.5%
 
1 8 < 0.1%
 
2 2 < 0.1%
 
(Missing) 17290 86.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_ccivil
Numeric

Distinct count26
Unique (%)0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean0.8679
Minimum0
Maximum409
Zeros (%)11.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile2
Maximum409
Range409
Interquartile range0

Descriptive statistics

Standard deviation11.481
Coef of variation13.229
Kurtosis794.21
Mean0.8679
MAD1.4418
Skewness26.521
Sum2352
Variance131.82
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2251 11.3%
 
1 305 1.5%
 
2 62 0.3%
 
3 33 0.2%
 
7 10 0.1%
 
4 9 < 0.1%
 
6 8 < 0.1%
 
5 5 < 0.1%
 
10 3 < 0.1%
 
8 2 < 0.1%
 
Other values (15) 22 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2251 11.3%
 
1 305 1.5%
 
2 62 0.3%
 
3 33 0.2%
 
4 9 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
409 1 < 0.1%
 
274 1 < 0.1%
 
241 1 < 0.1%
 
130 1 < 0.1%
 
128 2 < 0.1%
 

qt_coligados_centro
Numeric

Distinct count14
Unique (%)0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean0.17343
Minimum0
Maximum36
Zeros (%)12.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum36
Range36
Interquartile range0

Descriptive statistics

Standard deviation1.2963
Coef of variation7.4747
Kurtosis457.85
Mean0.17343
MAD0.32626
Skewness18.552
Sum470
Variance1.6805
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2549 12.7%
 
1 79 0.4%
 
2 37 0.2%
 
3 13 0.1%
 
6 10 0.1%
 
4 5 < 0.1%
 
8 5 < 0.1%
 
7 4 < 0.1%
 
5 3 < 0.1%
 
36 2 < 0.1%
 
Other values (3) 3 < 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2549 12.7%
 
1 79 0.4%
 
2 37 0.2%
 
3 13 0.1%
 
4 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
36 2 < 0.1%
 
19 1 < 0.1%
 
15 1 < 0.1%
 
9 1 < 0.1%
 
8 5 < 0.1%
 

qt_coligados_comercio
Numeric

Distinct count21
Unique (%)0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean0.94982
Minimum0
Maximum29
Zeros (%)7.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile4
Maximum29
Range29
Interquartile range1

Descriptive statistics

Standard deviation1.9071
Coef of variation2.0079
Kurtosis58.422
Mean0.94982
MAD0.99678
Skewness6.0607
Sum2574
Variance3.6372
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1422 7.1%
 
1 808 4.0%
 
2 238 1.2%
 
3 99 0.5%
 
4 42 0.2%
 
6 32 0.2%
 
5 21 0.1%
 
8 15 0.1%
 
7 13 0.1%
 
20 4 < 0.1%
 
Other values (10) 16 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1422 7.1%
 
1 808 4.0%
 
2 238 1.2%
 
3 99 0.5%
 
4 42 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
29 1 < 0.1%
 
28 1 < 0.1%
 
20 4 < 0.1%
 
18 1 < 0.1%
 
17 3 < 0.1%
 

qt_coligados_epp
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
0
 
2708
1
 
1
6
 
1
(Missing)
17290
ValueCountFrequency (%) 
0 2708 13.5%
 
1 1 < 0.1%
 
6 1 < 0.1%
 
(Missing) 17290 86.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_exterior
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
0
 
2677
1
 
18
2
 
13
(Missing)
17290
ValueCountFrequency (%) 
0 2677 13.4%
 
1 18 0.1%
 
2 13 0.1%
 
3 2 < 0.1%
 
(Missing) 17290 86.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_inapta
Highly correlated

This variable is highly correlated with coligada_mais_antiga_baixada and should be ignored for analysis

Correlation0.937

qt_coligados_industria
Numeric

Distinct count20
Unique (%)0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean0.41328
Minimum0
Maximum111
Zeros (%)11.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum111
Range111
Interquartile range0

Descriptive statistics

Standard deviation3.5146
Coef of variation8.5041
Kurtosis746.57
Mean0.41328
MAD0.69938
Skewness25.232
Sum1120
Variance12.353
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2293 11.5%
 
1 300 1.5%
 
2 52 0.3%
 
3 20 0.1%
 
4 16 0.1%
 
5 5 < 0.1%
 
10 5 < 0.1%
 
6 5 < 0.1%
 
12 2 < 0.1%
 
14 2 < 0.1%
 
Other values (9) 10 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2293 11.5%
 
1 300 1.5%
 
2 52 0.3%
 
3 20 0.1%
 
4 16 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
111 2 < 0.1%
 
48 1 < 0.1%
 
43 1 < 0.1%
 
28 1 < 0.1%
 
26 1 < 0.1%
 

qt_coligados_ltda
Numeric

Distinct count12
Unique (%)0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean0.086347
Minimum0
Maximum29
Zeros (%)12.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum29
Range29
Interquartile range0

Descriptive statistics

Standard deviation0.77469
Coef of variation8.9718
Kurtosis802.07
Mean0.086347
MAD0.16486
Skewness24.669
Sum234
Variance0.60015
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 2587 12.9%
 
1 92 0.5%
 
2 16 0.1%
 
3 5 < 0.1%
 
4 3 < 0.1%
 
9 2 < 0.1%
 
29 1 < 0.1%
 
7 1 < 0.1%
 
5 1 < 0.1%
 
16 1 < 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2587 12.9%
 
1 92 0.5%
 
2 16 0.1%
 
3 5 < 0.1%
 
4 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
29 1 < 0.1%
 
16 1 < 0.1%
 
9 2 < 0.1%
 
8 1 < 0.1%
 
7 1 < 0.1%
 

qt_coligados_matriz
Highly correlated

This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis

Correlation0.99805

qt_coligados_me
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
0
 
2699
1
 
11
(Missing)
17290
ValueCountFrequency (%) 
0 2699 13.5%
 
1 11 0.1%
 
(Missing) 17290 86.5%
 

qt_coligados_mei
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
0
 
2642
1
 
66
2
 
2
(Missing)
17290
ValueCountFrequency (%) 
0 2642 13.2%
 
1 66 0.3%
 
2 2 < 0.1%
 
(Missing) 17290 86.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_coligados_nordeste
Numeric

Distinct count36
Unique (%)0.2%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean1.9406
Minimum0
Maximum163
Zeros (%)5.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile7
Maximum163
Range163
Interquartile range2

Descriptive statistics

Standard deviation4.901
Coef of variation2.5255
Kurtosis443.11
Mean1.9406
MAD2.0463
Skewness15.574
Sum5259
Variance24.02
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1043 5.2%
 
1 796 4.0%
 
2 344 1.7%
 
3 178 0.9%
 
4 83 0.4%
 
6 51 0.3%
 
5 49 0.2%
 
7 37 0.2%
 
8 27 0.1%
 
9 18 0.1%
 
Other values (25) 84 0.4%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1043 5.2%
 
1 796 4.0%
 
2 344 1.7%
 
3 178 0.9%
 
4 83 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
163 1 < 0.1%
 
44 1 < 0.1%
 
40 1 < 0.1%
 
39 2 < 0.1%
 
36 2 < 0.1%
 

qt_coligados_norte
Numeric

Distinct count26
Unique (%)0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean0.81365
Minimum0
Maximum49
Zeros (%)9.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile3
Maximum49
Range49
Interquartile range1

Descriptive statistics

Standard deviation2.5349
Coef of variation3.1154
Kurtosis145.28
Mean0.81365
MAD1.0887
Skewness9.9856
Sum2205
Variance6.4256
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1813 9.1%
 
1 508 2.5%
 
2 184 0.9%
 
3 70 0.4%
 
4 45 0.2%
 
5 26 0.1%
 
6 18 0.1%
 
9 8 < 0.1%
 
7 5 < 0.1%
 
13 5 < 0.1%
 
Other values (15) 28 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1813 9.1%
 
1 508 2.5%
 
2 184 0.9%
 
3 70 0.4%
 
4 45 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
49 1 < 0.1%
 
46 2 < 0.1%
 
30 1 < 0.1%
 
25 2 < 0.1%
 
22 2 < 0.1%
 

qt_coligados_nula
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_coligados_sa
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation0.91043

qt_coligados_serviço
Numeric

Distinct count46
Unique (%)0.2%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean2.624
Minimum0
Maximum126
Zeros (%)5.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile8
Maximum126
Range126
Interquartile range2

Descriptive statistics

Standard deviation9.8838
Coef of variation3.7667
Kurtosis108.08
Mean2.624
MAD3.1567
Skewness9.7581
Sum7111
Variance97.69
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1000 5.0%
 
1 899 4.5%
 
2 310 1.6%
 
3 156 0.8%
 
4 75 0.4%
 
5 56 0.3%
 
6 41 0.2%
 
7 26 0.1%
 
9 25 0.1%
 
8 23 0.1%
 
Other values (35) 99 0.5%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1000 5.0%
 
1 899 4.5%
 
2 310 1.6%
 
3 156 0.8%
 
4 75 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
126 10 0.1%
 
110 1 < 0.1%
 
104 1 < 0.1%
 
90 2 < 0.1%
 
88 2 < 0.1%
 

qt_coligados_sudeste
Highly correlated

This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis

Correlation0.95437

qt_coligados_sul
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.91104

qt_coligados_suspensa
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
0
 
2709
1
 
1
(Missing)
17290
ValueCountFrequency (%) 
0 2709 13.5%
 
1 1 < 0.1%
 
(Missing) 17290 86.5%
 

qt_desligados
Highly correlated

This variable is highly correlated with qt_admitidos and should be ignored for analysis

Correlation0.93477

qt_desligados_12meses
Numeric

Distinct count60
Unique (%)0.3%
Missing (%)77.6%
Missing (n)15515
Infinite (%)0.0%
Infinite (n)0
Mean1.936
Minimum0
Maximum914
Zeros (%)15.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile6
Maximum914
Range914
Interquartile range1

Descriptive statistics

Standard deviation18.404
Coef of variation9.506
Kurtosis1565.1
Mean1.936
MAD2.9695
Skewness35.828
Sum8683
Variance338.7
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 3181 15.9%
 
1 535 2.7%
 
2 235 1.2%
 
3 129 0.6%
 
4 86 0.4%
 
5 62 0.3%
 
6 41 0.2%
 
7 38 0.2%
 
8 26 0.1%
 
9 17 0.1%
 
Other values (49) 135 0.7%
 
(Missing) 15515 77.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 3181 15.9%
 
1 535 2.7%
 
2 235 1.2%
 
3 129 0.6%
 
4 86 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
914 1 < 0.1%
 
557 1 < 0.1%
 
328 1 < 0.1%
 
249 1 < 0.1%
 
233 1 < 0.1%
 

qt_ex_funcionarios
Highly correlated

This variable is highly correlated with qt_desligados and should be ignored for analysis

Correlation1

qt_filiais
Numeric

Distinct count135
Unique (%)0.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean24.286
Minimum0
Maximum9647
Zeros (%)90.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile1
Maximum9647
Range9647
Interquartile range0

Descriptive statistics

Standard deviation435.24
Coef of variation17.921
Kurtosis421.85
Mean24.286
MAD47.437
Skewness20.326
Sum4.8572e+05
Variance1.8944e+05
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 2.5000e+00 3.5000e+00 ... 5.5050e+02 2.5115e+03 8.4785e+03 9.3405e+03 9.6470e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 18181 90.9%
 
1 826 4.1%
 
2 254 1.3%
 
3 125 0.6%
 
4 78 0.4%
 
5 44 0.2%
 
6 32 0.2%
 
7 27 0.1%
 
9 24 0.1%
 
11 22 0.1%
 
Other values (125) 387 1.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 18181 90.9%
 
1 826 4.1%
 
2 254 1.3%
 
3 125 0.6%
 
4 78 0.4%
 

Maximum 5 values

ValueCountFrequency (%) 
9647 10 0.1%
 
9411 14 0.1%
 
9270 11 0.1%
 
7687 7 < 0.1%
 
5491 3 < 0.1%
 

qt_funcionarios
Highly correlated

This variable is highly correlated with idade_de_54_a_58 and should be ignored for analysis

Correlation0.9349

qt_funcionarios_12meses
Highly correlated

This variable is highly correlated with qt_funcionarios and should be ignored for analysis

Correlation0.99486

qt_funcionarios_24meses
Highly correlated

This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis

Correlation0.97492

qt_funcionarios_coligados
Highly correlated

This variable is highly correlated with coligada_mais_nova_baixada and should be ignored for analysis

Correlation0.94351

qt_funcionarios_coligados_gp
Highly correlated

This variable is highly correlated with max_funcionarios_coligados_gp and should be ignored for analysis

Correlation0.99611

qt_funcionarios_grupo
Numeric

Distinct count355
Unique (%)1.8%
Missing (%)75.3%
Missing (n)15052
Infinite (%)0.0%
Infinite (n)0
Mean8546.4
Minimum0
Maximum2.6687e+06
Zeros (%)6.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median2
Q38
95-th percentile412
Maximum2.6687e+06
Range2.6687e+06
Interquartile range7

Descriptive statistics

Standard deviation1.2367e+05
Coef of variation14.471
Kurtosis345.6
Mean8546.4
MAD16644
Skewness17.932
Sum4.2287e+07
Variance1.5295e+10
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1208 6.0%
 
1 919 4.6%
 
2 488 2.4%
 
3 327 1.6%
 
4 245 1.2%
 
5 201 1.0%
 
6 137 0.7%
 
7 133 0.7%
 
8 90 0.4%
 
10 68 0.3%
 
Other values (344) 1132 5.7%
 
(Missing) 15052 75.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1208 6.0%
 
1 919 4.6%
 
2 488 2.4%
 
3 327 1.6%
 
4 245 1.2%
 

Maximum 5 values

ValueCountFrequency (%) 
2.6687e+06 7 < 0.1%
 
1.4844e+06 11 0.1%
 
3.8039e+05 2 < 0.1%
 
3.7704e+05 1 < 0.1%
 
3.511e+05 10 0.1%
 

qt_ramos_coligados
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation0.91284

qt_regioes_coligados
Numeric

Distinct count7
Unique (%)< 0.1%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean1.1967
Minimum1
Maximum6
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum6
Range5
Interquartile range0

Descriptive statistics

Standard deviation0.59473
Coef of variation0.49698
Kurtosis15.101
Mean1.1967
MAD0.34226
Skewness3.7108
Sum3243
Variance0.3537
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
1 2358 11.8%
 
2 244 1.2%
 
4 54 0.3%
 
3 45 0.2%
 
5 8 < 0.1%
 
6 1 < 0.1%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 2358 11.8%
 
2 244 1.2%
 
3 45 0.2%
 
4 54 0.3%
 
5 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6 1 < 0.1%
 
5 8 < 0.1%
 
4 54 0.3%
 
3 45 0.2%
 
2 244 1.2%
 

qt_socios
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation0.93688

qt_socios_coligados
Numeric

Distinct count86
Unique (%)0.4%
Missing (%)86.5%
Missing (n)17290
Infinite (%)0.0%
Infinite (n)0
Mean9.0266
Minimum1
Maximum989
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q34
95-th percentile22
Maximum989
Range988
Interquartile range3

Descriptive statistics

Standard deviation46.887
Coef of variation5.1943
Kurtosis164.56
Mean9.0266
MAD11.815
Skewness11.901
Sum24462
Variance2198.4
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 1105 5.5%
 
2 559 2.8%
 
3 249 1.2%
 
4 178 0.9%
 
5 102 0.5%
 
6 80 0.4%
 
7 59 0.3%
 
8 43 0.2%
 
9 32 0.2%
 
11 29 0.1%
 
Other values (75) 274 1.4%
 
(Missing) 17290 86.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1105 5.5%
 
2 559 2.8%
 
3 249 1.2%
 
4 178 0.9%
 
5 102 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
989 1 < 0.1%
 
683 1 < 0.1%
 
675 1 < 0.1%
 
616 1 < 0.1%
 
506 10 0.1%
 

qt_socios_feminino
Numeric

Distinct count13
Unique (%)0.1%
Missing (%)68.8%
Missing (n)13768
Infinite (%)0.0%
Infinite (n)0
Mean1.0968
Minimum1
Maximum17
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q31
95-th percentile2
Maximum17
Range16
Interquartile range0

Descriptive statistics

Standard deviation0.52488
Coef of variation0.47858
Kurtosis353.79
Mean1.0968
MAD0.17995
Skewness15.271
Sum6835
Variance0.2755
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 5795 29.0%
 
2 368 1.8%
 
3 43 0.2%
 
4 11 0.1%
 
5 5 < 0.1%
 
15 2 < 0.1%
 
9 2 < 0.1%
 
6 2 < 0.1%
 
11 1 < 0.1%
 
10 1 < 0.1%
 
Other values (2) 2 < 0.1%
 
(Missing) 13768 68.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 5795 29.0%
 
2 368 1.8%
 
3 43 0.2%
 
4 11 0.1%
 
5 5 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
17 1 < 0.1%
 
15 2 < 0.1%
 
11 1 < 0.1%
 
10 1 < 0.1%
 
9 2 < 0.1%
 

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation0.97996

qt_socios_pep
Highly correlated

This variable is highly correlated with qt_socios_masculino and should be ignored for analysis

Correlation0.99002

qt_socios_pf
Highly correlated

This variable is highly correlated with qt_socios_pep and should be ignored for analysis

Correlation0.98016

qt_socios_pj
Numeric

Distinct count7
Unique (%)< 0.1%
Missing (%)24.8%
Missing (n)4959
Infinite (%)0.0%
Infinite (n)0
Mean0.018283
Minimum0
Maximum7
Zeros (%)74.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum7
Range7
Interquartile range0

Descriptive statistics

Standard deviation0.18196
Coef of variation9.9523
Kurtosis260.16
Mean0.018283
MAD0.036112
Skewness13.395
Sum275
Variance0.03311
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%) 
0 14854 74.3%
 
1 114 0.6%
 
2 63 0.3%
 
3 8 < 0.1%
 
7 1 < 0.1%
 
4 1 < 0.1%
 
(Missing) 4959 24.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 14854 74.3%
 
1 114 0.6%
 
2 63 0.3%
 
3 8 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
7 1 < 0.1%
 
4 1 < 0.1%
 
3 8 < 0.1%
 
2 63 0.3%
 
1 114 0.6%
 

qt_socios_pj_ativos
Highly correlated

This variable is highly correlated with qt_socios_pj and should be ignored for analysis

Correlation0.96123

qt_socios_pj_baixados
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)99.1%
Missing (n)19813
0
 
185
1
 
2
(Missing)
19813
ValueCountFrequency (%) 
0 185 0.9%
 
1 2 < 0.1%
 
(Missing) 19813 99.1%
 

qt_socios_pj_inaptos
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)99.1%
Missing (n)19813
0
 
185
1
 
1
2
 
1
(Missing)
19813
ValueCountFrequency (%) 
0 185 0.9%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
(Missing) 19813 99.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

qt_socios_pj_nulos
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)99.1%
Missing (n)19813
0
 
186
1
 
1
(Missing)
19813
ValueCountFrequency (%) 
0 186 0.9%
 
1 1 < 0.1%
 
(Missing) 19813 99.1%
 

qt_socios_pj_suspensos
Constant

This variable is constant and should be ignored for analysis

Constant value0.0

qt_socios_st_regular
Highly correlated

This variable is highly correlated with qt_socios_pf and should be ignored for analysis

Correlation0.98725

qt_socios_st_suspensa
Highly correlated

This variable is highly correlated with min_filiais_coligados and should be ignored for analysis

Correlation1

qt_ufs_coligados
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation0.92173

setor
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)74
COMERCIO
9146
SERVIÇO
8220
INDUSTRIA
 
1280
Other values (2)
 
1280
ValueCountFrequency (%) 
COMERCIO 9146 45.7%
 
SERVIÇO 8220 41.1%
 
INDUSTRIA 1280 6.4%
 
CONSTRUÇÃO CIVIL 1132 5.7%
 
AGROPECUARIA 148 0.7%
 
(Missing) 74 0.4%
 
Max length16
Mean length8.1169
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

sg_uf
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
MA
5563
RN
4293
AM
3535
Other values (3)
6609
ValueCountFrequency (%) 
MA 5563 27.8%
 
RN 4293 21.5%
 
AM 3535 17.7%
 
PI 3279 16.4%
 
RO 2419 12.1%
 
AC 911 4.6%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sg_uf_matriz
Categorical

Distinct count27
Unique (%)0.1%
Missing (%)0.4%
Missing (n)74
MA
5446
RN
4222
AM
3440
Other values (23)
6818
ValueCountFrequency (%) 
MA 5446 27.2%
 
RN 4222 21.1%
 
AM 3440 17.2%
 
PI 3225 16.1%
 
RO 2357 11.8%
 
AC 884 4.4%
 
SP 116 0.6%
 
CE 44 0.2%
 
DF 40 0.2%
 
RJ 25 0.1%
 
Other values (16) 127 0.6%
 
(Missing) 74 0.4%
 
Max length3
Mean length2.0037
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

sum_faturamento_estimado_coligadas
Highly correlated

This variable is highly correlated with max_vl_folha_coligados and should be ignored for analysis

Correlation0.9227

total
Highly correlated

This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis

Correlation0.96062

total_filiais_coligados
Highly correlated

This variable is highly correlated with max_vl_folha_coligados and should be ignored for analysis

Correlation0.92829

tx_crescimento_12meses
Numeric

Distinct count287
Unique (%)1.4%
Missing (%)84.1%
Missing (n)16819
Infinite (%)0.0%
Infinite (n)0
Mean2.3591
Minimum-100
Maximum8566.7
Zeros (%)9.7%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-66.667
Q10
Median0
Q30
95-th percentile50
Maximum8566.7
Range8666.7
Interquartile range0

Descriptive statistics

Standard deviation158.8
Coef of variation67.314
Kurtosis2662.7
Mean2.3591
MAD22.46
Skewness49.472
Sum7504.3
Variance25218
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1933 9.7%
 
-100 124 0.6%
 
-50 83 0.4%
 
-33.333 70 0.4%
 
100 49 0.2%
 
50 47 0.2%
 
-25 44 0.2%
 
33.333 38 0.2%
 
-16.667 33 0.2%
 
20 30 0.1%
 
Other values (276) 730 3.6%
 
(Missing) 16819 84.1%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 124 0.6%
 
-97.826 1 < 0.1%
 
-95.69 1 < 0.1%
 
-93.827 1 < 0.1%
 
-92.308 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
8566.7 1 < 0.1%
 
700 1 < 0.1%
 
600 1 < 0.1%
 
500 2 < 0.1%
 
480 1 < 0.1%
 

tx_crescimento_24meses
Numeric

Distinct count423
Unique (%)2.1%
Missing (%)83.9%
Missing (n)16772
Infinite (%)0.0%
Infinite (n)0
Mean-12.264
Minimum-100
Maximum6700
Zeros (%)5.9%
Mini histogram

Quantile statistics

Minimum-100
5-th percentile-100
Q1-45.175
Median-0.52502
Q30
95-th percentile66.083
Maximum6700
Range6800
Interquartile range45.175

Descriptive statistics

Standard deviation136.26
Coef of variation-11.11
Kurtosis1828.6
Mean-12.264
MAD39.516
Skewness37.678
Sum-39589
Variance18566
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1185 5.9%
 
-100 349 1.7%
 
-50 163 0.8%
 
-33.333 143 0.7%
 
-25 71 0.4%
 
-66.667 61 0.3%
 
100 59 0.3%
 
-20 58 0.3%
 
50 51 0.3%
 
-40 37 0.2%
 
Other values (412) 1051 5.3%
 
(Missing) 16772 83.9%
 

Minimum 5 values

ValueCountFrequency (%) 
-100 349 1.7%
 
-99.216 1 < 0.1%
 
-98.164 1 < 0.1%
 
-98.039 1 < 0.1%
 
-96.835 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
6700 1 < 0.1%
 
1000 2 < 0.1%
 
700 2 < 0.1%
 
600 2 < 0.1%
 
500 6 < 0.1%
 

tx_rotatividade
Numeric

Distinct count311
Unique (%)1.6%
Missing (%)77.6%
Missing (n)15515
Infinite (%)0.0%
Infinite (n)0
Mean9.2241
Minimum0
Maximum320
Zeros (%)17.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile52.29
Maximum320
Range320
Interquartile range0

Descriptive statistics

Standard deviation26.36
Coef of variation2.8577
Kurtosis31.835
Mean9.2241
MAD14.452
Skewness4.9103
Sum41370
Variance694.85
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 3489 17.4%
 
40 52 0.3%
 
28.571 51 0.3%
 
22.222 39 0.2%
 
18.182 38 0.2%
 
33.333 37 0.2%
 
66.667 27 0.1%
 
100 25 0.1%
 
15.385 25 0.1%
 
25 23 0.1%
 
Other values (300) 679 3.4%
 
(Missing) 15515 77.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 3489 17.4%
 
1.2195 1 < 0.1%
 
1.3986 1 < 0.1%
 
1.5748 1 < 0.1%
 
1.9417 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
320 1 < 0.1%
 
311.11 1 < 0.1%
 
266.67 1 < 0.1%
 
263.83 1 < 0.1%
 
250 1 < 0.1%
 

vl_faturamento_estimado_aux
Highly correlated

This variable is highly correlated with total and should be ignored for analysis

Correlation0.97315

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count949
Unique (%)4.7%
Missing (%)5.8%
Missing (n)1154
Infinite (%)0.0%
Infinite (n)0
Mean2.7649e+08
Minimum41213
Maximum2.2276e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum41213
5-th percentile50000
Q11.8546e+05
Median2.1e+05
Q32.1e+05
95-th percentile2.5964e+06
Maximum2.2276e+11
Range2.2276e+11
Interquartile range24542

Descriptive statistics

Standard deviation6.6109e+09
Coef of variation23.91
Kurtosis895.5
Mean2.7649e+08
MAD5.4477e+08
Skewness29.359
Sum5.2108e+12
Variance4.3704e+19
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.1e+05 9961 49.8%
 
50000 4171 20.9%
 
9.3e+05 614 3.1%
 
1.8546e+05 321 1.6%
 
4.2e+05 276 1.4%
 
1.2364e+05 252 1.3%
 
3.7092e+05 217 1.1%
 
2.4728e+05 157 0.8%
 
5.5637e+05 116 0.6%
 
7.4183e+05 90 0.4%
 
Other values (938) 2671 13.4%
 
(Missing) 1154 5.8%
 

Minimum 5 values

ValueCountFrequency (%) 
41213 75 0.4%
 
50000 4171 20.9%
 
51516 12 0.1%
 
61819 85 0.4%
 
82426 25 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2.2276e+11 7 < 0.1%
 
1.8943e+11 10 0.1%
 
1.8121e+11 2 < 0.1%
 
8.9316e+10 3 < 0.1%
 
4.3415e+10 11 0.1%
 

vl_folha_coligados
Highly correlated

This variable is highly correlated with total_filiais_coligados and should be ignored for analysis

Correlation0.91586

vl_folha_coligados_gp
Highly correlated

This variable is highly correlated with vl_folha_coligados and should be ignored for analysis

Correlation0.922

vl_frota
Highly correlated

This variable is highly correlated with qt_socios_pj_inaptos and should be ignored for analysis

Correlation0.9575

vl_idade_maxima_socios_pj
Highly correlated

This variable is highly correlated with idade_media_coligadas_baixadas and should be ignored for analysis

Correlation0.98969

vl_idade_media_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis

Correlation0.95057

vl_idade_minima_socios_pj
Highly correlated

This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis

Correlation0.91241

vl_potenc_cons_oleo_gas
Numeric

Distinct count31
Unique (%)0.2%
Missing (%)99.2%
Missing (n)19845
Infinite (%)0.0%
Infinite (n)0
Mean14.395
Minimum1
Maximum360
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median4
Q310
95-th percentile69.8
Maximum360
Range359
Interquartile range8

Descriptive statistics

Standard deviation36.539
Coef of variation2.5382
Kurtosis54.772
Mean14.395
MAD16.731
Skewness6.5746
Sum2231.3
Variance1335.1
Memory size952.5 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2 49 0.2%
 
1 14 0.1%
 
4 14 0.1%
 
6 12 0.1%
 
8 10 0.1%
 
3 9 < 0.1%
 
10 7 < 0.1%
 
14 5 < 0.1%
 
45 5 < 0.1%
 
7 4 < 0.1%
 
Other values (20) 26 0.1%
 
(Missing) 19845 99.2%
 

Minimum 5 values

ValueCountFrequency (%) 
1 14 0.1%
 
2 49 0.2%
 
3 9 < 0.1%
 
4 14 0.1%
 
5 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
360 1 < 0.1%
 
180 1 < 0.1%
 
118 1 < 0.1%
 
102 1 < 0.1%
 
78.3 1 < 0.1%
 

vl_total_tancagem
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.99476

vl_total_tancagem_grupo
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.90065

vl_total_veiculos_antt
Highly correlated

This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis

Correlation0.99317

vl_total_veiculos_antt_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt and should be ignored for analysis

Correlation1

vl_total_veiculos_leves
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt_grupo and should be ignored for analysis

Correlation0.9581

vl_total_veiculos_leves_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt and should be ignored for analysis

Correlation0.95917

vl_total_veiculos_pesados
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt_grupo and should be ignored for analysis

Correlation0.97758

vl_total_veiculos_pesados_grupo
Highly correlated

This variable is highly correlated with vl_total_veiculos_antt and should be ignored for analysis

Correlation0.97729

Correlations

Missing values

Sample

First rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
0536.366667NaN57.3NaNDE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 1.500.000,01 A R$ 4.800.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTAINDUSTRIA DA CONSTRUCAOACIMA DE 1 ANOVERDE2005-03-25NaN21809443.022019443.0FalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN1.025.0NaNa6984c3ae395090e3bee8ad63c3758b110de096d5d819583a784a113726db8491.0NaN1.04.06.05.03.04.02.0NaN10 a 1514.457534536.36666747.0220.477778220.477778NaN44.057.341.013188096.013188096.01.091.093.26666793.2666675275238.55275238.53.634907e+063.669907e+061.00000036.2543.73846213.3091952343978.02343978.019.166667210000.0210000.01.06.019.166667-0.933333638798.4638798.4ENTIDADES EMPRESARIAISCONSTRUCAO DE EDIFICIOSLESTE POTIGUARNATALCONSTRUCAO23.00.0100.0145.00.0NaNNaNNaNNaN8.06.06.00.00.00.00.00.00.06.00.00.00.01.00.00.00.00.00.06.00.00.06.00.00.00.05.00.00.00.0119.00.0119.0026.026.027.0145.0145.026.05.01.02.08.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN2.0CONSTRUÇÃO CIVILRNRN21809443.026.01.00.0-3.7037040.03132172.83132172.89375912.09375912.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
1NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALBAIXASERVICOS DE ALOJAMENTO/ALIMENTACAOATE 1 ANOCINZA2017-05-12468.93NaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c47fdef50b33f4f56f05NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.463014NaN27.0NaNNaNNaN27.0NaN27.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAOCENTRO NORTE PIAUIENSETERESINAALOJAMENTO E ALIMENTACAO9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOPIPINaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
2NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-09-26713.50NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02edc5147bc2a2535b08NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 107.093151NaN32.0NaNNaNNaN32.0NaN32.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRECENTRO AMAZONENSEMANAUSTRANSPORTE ARMAZENAGEM E CORREIO26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaNNaN1.0NaNSERVIÇOAMAMNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
3NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIASERVICOS DIVERSOSACIMA DE 1 ANOAMARELO2012-04-25475.73NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN3348900fe63216a439d2e5238c79ddd46ede454df7b9d8c24ac33eb21d4b21efNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 106.512329NaN36.0NaNNaNNaN36.0NaN36.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSREPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFORMATICA E COMUNICACAO E DE OBJETOS PESSOAIS E DOMESTICOSCENTRO AMAZONENSEMANAUSOUTRAS ATIVIDADES DE SERVICOS26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
4NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALALTASERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOSACIMA DE 1 ANOVERDE2015-08-172874.04NaNNaNFalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4b102c769f7611ab29fNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 53.200000NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSSERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICASLESTE POTIGUARNATALATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS27.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNSERVIÇORNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
5NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTAQUIMICA-PETROQUIMICAACIMA DE 1 ANOLARANJA2005-11-03NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb62f5bd2ebec4860a392NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2038.079452NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOSOESTE POTIGUARPAU DOS FERROSINDUSTRIAS DE TRANSFORMACAO48.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNINDUSTRIARNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
6NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIATRANSPORTE, ARMAZENAGEM E CORREIOACIMA DE 1 ANOAMARELO2011-07-21NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueTrueTrueTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN8bf37c178778e537b108e58bf20552abe10c3a7fae129b04b52506188e7176daNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN5 a 107.276712NaN63.0NaNNaNNaN63.0NaN63.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSTRANSPORTE TERRESTRENORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISTRANSPORTE ARMAZENAGEM E CORREIO23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇOMAMANaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
7NaNNaNNaNNaNNaNNaNNaNEMPRESARIO INDIVIDUALALTASERVICOS ADMINISTRATIVOSNaNNaN2018-10-09NaNNaNNaNFalseTrueFalseFalseTrueFalseTrueNaNNaNTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77dd2d5cb382605b7be79NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<= 10.052055NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSAGENCIAS DE VIAGENS OPERADORES TURISTICOS E SERVICOS DE RESERVASLESTE POTIGUARNATALATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARESNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaN1.0NaNNaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇORNRNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
8NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOACOOPERATIVAALTABENS DE CONSUMOACIMA DE 1 ANOAZUL2006-07-27247.88NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseTrueTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN6c45aabb849a760a3a7107c7a61262642f683feb8912a41a859f69fe4ce02b1cNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10 a 1512.263014NaN36.0NaNNaNNaN36.0NaN36.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES EMPRESARIAISFABRICACAO DE PRODUTOS DIVERSOSCENTRO AMAZONENSEPARINTINSINDUSTRIAS DE TRANSFORMACAO24.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN2.0NaNNaN1.0NaN2.00.0NaNNaNNaNNaNNaN1.0NaNNaNINDUSTRIAAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
9367.666667NaN176.7NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOVERMELHO2004-10-301042.854200000.013440000.0FalseFalseFalseFalseFalseFalseFalseFalseFalseFalseNAOFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b19267e6600f46121b726e8NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN15 a 2017.942466367.66666752.0235.478333235.478333NaN52.0176.752.0210000.0840000.03.0NaNNaNNaNNaNNaN2.100000e+056.720000e+052.428571NaNNaNNaNNaNNaNNaN210000.0210000.02.0NaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTAOESTE POTIGUARMOSSOROCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS54.0NaNNaNNaNNaNNaNNaNNaNNaNNaN5.06.00.00.00.00.00.00.020.00.00.00.020.00.00.00.00.00.011.00.00.020.00.00.00.00.00.00.00.0NaNNaNNaN3NaNNaNNaNNaNNaNNaN3.01.01.020.0NaN1.0NaN1.00.0NaNNaNNaNNaNNaNNaNNaN1.0COMERCIORNRN1050000.0NaN17.0NaNNaNNaN210000.0840000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0

Last rows

coligada_mais_antiga_ativacoligada_mais_antiga_baixadacoligada_mais_nova_ativacoligada_mais_nova_baixadade_faixa_faturamento_estimadode_faixa_faturamento_estimado_grupode_indicador_telefonede_natureza_juridicade_nivel_atividadede_ramode_saude_rescenciade_saude_tributariadt_situacaoempsetorcensitariofaixarendapopulacaofaturamento_est_coligadosfaturamento_est_coligados_gpfl_anttfl_emailfl_eppfl_ltdafl_matrizfl_mefl_meifl_optante_simeifl_optante_simplesfl_passivel_issfl_rmfl_safl_simples_irregularfl_spafl_st_especialfl_telefonefl_veiculograu_instrucao_macro_analfabetograu_instrucao_macro_desconhecidograu_instrucao_macro_escolaridade_fundamentalgrau_instrucao_macro_escolaridade_mediagrau_instrucao_macro_escolaridade_superiorididade_acima_de_58idade_ate_18idade_de_19_a_23idade_de_24_a_28idade_de_29_a_33idade_de_34_a_38idade_de_39_a_43idade_de_44_a_48idade_de_49_a_53idade_de_54_a_58idade_emp_catidade_empresa_anosidade_maxima_coligadasidade_maxima_sociosidade_media_coligadasidade_media_coligadas_ativasidade_media_coligadas_baixadasidade_media_sociosidade_minima_coligadasidade_minima_sociosmax_faturamento_est_coligadosmax_faturamento_est_coligados_gpmax_filiais_coligadosmax_funcionarios_coligados_gpmax_meses_servicosmax_meses_servicos_allmax_vl_folha_coligadosmax_vl_folha_coligados_gpmedia_faturamento_est_coligadosmedia_faturamento_est_coligados_gpmedia_filiais_coligadosmedia_funcionarios_coligados_gpmedia_meses_servicosmedia_meses_servicos_allmedia_vl_folha_coligadosmedia_vl_folha_coligados_gpmeses_ultima_contratacacomin_faturamento_est_coligadosmin_faturamento_est_coligados_gpmin_filiais_coligadosmin_funcionarios_coligados_gpmin_meses_servicosmin_meses_servicos_allmin_vl_folha_coligadosmin_vl_folha_coligados_gpnatureza_juridica_macronm_divisaonm_meso_regiaonm_micro_regiaonm_segmentonu_meses_rescenciapercent_func_genero_fempercent_func_genero_mascqt_admitidosqt_admitidos_12mesesqt_alteracao_socio_180dqt_alteracao_socio_365dqt_alteracao_socio_90dqt_alteracao_socio_totalqt_artqt_coligadasqt_coligadosqt_coligados_agropecuariaqt_coligados_atividade_altoqt_coligados_atividade_baixoqt_coligados_atividade_inativoqt_coligados_atividade_medioqt_coligados_atividade_mt_baixoqt_coligados_ativoqt_coligados_baixadaqt_coligados_ccivilqt_coligados_centroqt_coligados_comercioqt_coligados_eppqt_coligados_exteriorqt_coligados_inaptaqt_coligados_industriaqt_coligados_ltdaqt_coligados_matrizqt_coligados_meqt_coligados_meiqt_coligados_nordesteqt_coligados_norteqt_coligados_nulaqt_coligados_saqt_coligados_serviçoqt_coligados_sudesteqt_coligados_sulqt_coligados_suspensaqt_desligadosqt_desligados_12mesesqt_ex_funcionariosqt_filiaisqt_funcionariosqt_funcionarios_12mesesqt_funcionarios_24mesesqt_funcionarios_coligadosqt_funcionarios_coligados_gpqt_funcionarios_grupoqt_ramos_coligadosqt_regioes_coligadosqt_sociosqt_socios_coligadosqt_socios_femininoqt_socios_masculinoqt_socios_pepqt_socios_pfqt_socios_pjqt_socios_pj_ativosqt_socios_pj_baixadosqt_socios_pj_inaptosqt_socios_pj_nulosqt_socios_pj_suspensosqt_socios_st_regularqt_socios_st_suspensaqt_ufs_coligadossetorsg_ufsg_uf_matrizsum_faturamento_estimado_coligadastotaltotal_filiais_coligadostx_crescimento_12mesestx_crescimento_24mesestx_rotatividadevl_faturamento_estimado_auxvl_faturamento_estimado_grupo_auxvl_folha_coligadosvl_folha_coligados_gpvl_frotavl_idade_maxima_socios_pjvl_idade_media_socios_pjvl_idade_minima_socios_pjvl_potenc_cons_oleo_gasvl_total_tancagemvl_total_tancagem_grupovl_total_veiculos_anttvl_total_veiculos_antt_grupovl_total_veiculos_levesvl_total_veiculos_leves_grupovl_total_veiculos_pesadosvl_total_veiculos_pesados_grupo
19990NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALMEDIASERVICOS DE ALOJAMENTO/ALIMENTACAOATE 1 ANOCINZA2017-10-16NaNNaNNaNFalseFalseFalseFalseTrueFalseTrueNaNNaNTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN4fb067050f1018db292f3f9ff496c612f97022dfb3116fc27df596da0e9baeb4NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.032877NaN47.0NaNNaNNaN47.0NaN47.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSALIMENTACAOOESTE POTIGUARMOSSOROALOJAMENTO E ALIMENTACAO9.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇORNRNNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19991NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALMEDIACOMERCIO VAREJISTAACIMA DE 1 ANOAMARELO2015-08-241001.62NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNb2023cb600b98d867ab3c6457595e09b4e4ce55f4073b69318c0cb8e039e2e3eNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 53.180822NaN40.0NaNNaNNaN40.0NaN40.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSEMANAUSCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19992NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNASSOCIACAO PRIVADAMEDIASERVICOS DIVERSOSACIMA DE 1 ANOAMARELO2007-10-23983.72NaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNb77bc38bab845b5a4bca2c9e7217f4347e250a3b04ca05821892f90e594dcc5bNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10 a 1511.021918NaN50.0NaNNaNNaN50.0NaN50.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES SEM FINS LUCRATIVOSATIVIDADES DE ORGANIZACOES ASSOCIATIVASNaNNaNOUTRAS ATIVIDADES DE SERVICOS22.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNSERVIÇORORONaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19993519.000000NaN67.333333NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNSOCIEDADE EMPRESARIA LIMITADAALTASERVICOS DE SAUDEATE 1 ANOVERDE2017-05-152361.388.654688e+058.654688e+05FalseTrueFalseFalseTrueFalseFalseNaNNaNTrueSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN6770a72393f882b94a52b695be84fd3b2bd67c710991e50b379a3dd7c21e0032NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 51.454795519.00000031.0282.433333282.433333NaN30.567.33333330.0535766.4535766.4NaN9.0NaNNaN267883.2267883.2288489.589844288489.589844NaN4.333333NaNNaN1.442448e+051.442448e+05NaN41212.841212.8NaN1.0NaNNaN20606.420606.4ENTIDADES EMPRESARIAISATIVIDADES DE ATENCAO A SAUDE HUMANACENTRO NORTE PIAUIENSETERESINASAUDE HUMANA E SERVICOS SOCIAIS9.0NaNNaNNaNNaNNaNNaNNaNNaNNaN3.03.00.00.00.00.00.00.03.00.00.00.00.00.00.00.00.00.03.00.00.03.00.00.00.03.00.00.00.0NaNNaNNaN0NaNNaNNaN13.013.0NaN2.01.02.03.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN2.0SERVIÇOPIPI8.654688e+05NaNNaNNaNNaNNaN210000.0210000.04.327344e+054.327344e+05NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19994111.500000NaN111.500000NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS DE SAUDEACIMA DE 1 ANOVERDE2006-09-212713.187.418304e+057.418304e+05FalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseTrueNaNNaNNaNNaNNaNf36f63a5e547a49bc526c5fbc4cbf0b7a6a73f52c3d358f1ce2793f948624901NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10 a 1512.109589111.50000042.0111.500000111.500000NaN40.0111.50000038.0741830.4741830.4NaN6.0NaNNaN370915.2370915.2741830.375000741830.375000NaN6.000000NaNNaN3.709152e+053.709152e+05NaN741830.4741830.4NaN6.0NaNNaN370915.2370915.2ENTIDADES EMPRESARIAISATIVIDADES DE ATENCAO A SAUDE HUMANANORTE MARANHENSEAGLOMERACAO URBANA DE SAO LUISSAUDE HUMANA E SERVICOS SOCIAIS23.0NaNNaNNaNNaNNaNNaNNaNNaNNaN1.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.01.00.00.00.01.00.00.00.0NaNNaNNaN0NaNNaNNaN6.06.0NaN1.01.02.02.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOMAMA7.418304e+05NaNNaNNaNNaNNaN210000.0210000.03.709152e+053.709152e+05NaNNaNNaNNaNNaNNaNNaNNaNNaN3.03.00.00.0
19995154.366667NaN154.366667NaNDE R$ 1.500.000,01 A R$ 4.800.000,00DE R$ 1.500.000,01 A R$ 4.800.000,00BOASOCIEDADE EMPRESARIA LIMITADAALTASERVICOS DE ALOJAMENTO/ALIMENTACAOACIMA DE 1 ANOVERDE2012-05-254015.872.100000e+052.100000e+05FalseTrueFalseFalseTrueFalseFalseFalseTrueTrueSIMFalseFalseFalseFalseTrueFalseNaNNaN2.014.01.051fb6735b03824e0545f2d6a3b99e8b14f7f6baca0658d3e354115306a94c7f7NaNNaN1.03.04.04.03.01.0NaN1.05 a 106.430137154.36666751.0154.366667154.366667NaN38.5154.36666726.0210000.0210000.0NaNNaN76.26666776.266667NaNNaN210000.000000210000.000000NaNNaN33.24259313.633663NaNNaN2.033333210000.0210000.0NaNNaN2.033333-0.566667NaNNaNENTIDADES EMPRESARIAISALOJAMENTOCENTRO AMAZONENSEMANAUSALOJAMENTO E ALIMENTACAO23.076.4723.53101.04.0NaNNaNNaNNaN2.01.01.00.00.00.00.00.00.01.00.00.00.00.00.00.00.00.00.01.00.00.00.00.00.00.01.01.00.00.083.03.083.0018.017.021.0NaNNaN17.01.01.02.02.01.01.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN1.0SERVIÇOAMAM2.100000e+0517.0NaN5.882353-14.28571417.1428572101852.82101852.8NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19996NaNNaNNaNNaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOAZUL2007-02-15NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaNd42b79be8d30d97765a93d5e8b46add7e8eb47e56f44009511bc12ea4cc928f5NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10 a 1511.706849NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTACENTRO AMAZONENSERIO PRETO DA EVACOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN210000.0210000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19997NaNNaNNaNNaNDE R$ 360.000,01 A R$ 1.500.000,00DE R$ 360.000,01 A R$ 1.500.000,00NaNASSOCIACAO PRIVADABAIXASERVICOS DIVERSOSACIMA DE 1 ANOLARANJA2005-11-03NaNNaNNaNFalseFalseFalseFalseTrueFalseFalseFalseFalseTrueSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN078a15ab28d75f23c4b523eae726f9646f4bbe5993312cedd8e54ce56a7f5be3NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN> 2021.435616NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNENTIDADES SEM FINS LUCRATIVOSATIVIDADES DE ORGANIZACOES ASSOCIATIVASOESTE MARANHENSEIMPERATRIZOUTRAS ATIVIDADES DE SERVICOS23.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaN1.00.0NaNNaNNaNNaNNaNNaNNaNNaNSERVIÇOMAMANaNNaNNaNNaNNaNNaN930000.0930000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19998NaNNaNNaNNaNATE R$ 81.000,00ATE R$ 81.000,00NaNEMPRESARIO INDIVIDUALALTACOMERCIO VAREJISTAACIMA DE 1 ANOVERDE2016-06-03568.10NaNNaNFalseFalseFalseFalseTrueFalseTrueTrueTrueFalseNAOFalseFalseFalseFalseTrueFalseNaNNaNNaNNaNNaN45cf0a01eb00882ad27e343906c524b38b8440a8e5d76343ed3ee95768d43aecNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1 a 52.402740NaN34.0NaNNaNNaN34.0NaN34.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNOUTROSCOMERCIO VAREJISTASUDOESTE AMAZONENSEALTO SOLIMOESCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS26.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaN1.0NaN1.00.0NaNNaNNaNNaNNaN1.0NaNNaNCOMERCIOAMAMNaNNaNNaNNaNNaNNaN50000.050000.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0
19999183.266667NaN63.900000NaNDE R$ 81.000,01 A R$ 360.000,00DE R$ 81.000,01 A R$ 360.000,00NaNSOCIEDADE EMPRESARIA LIMITADAMUITO BAIXACOMERCIO E REPARACAO DE VEICULOSACIMA DE 1 ANOLARANJA2005-06-30NaN4.866120e+064.866120e+06FalseFalseFalseTrueTrueFalseFalseFalseFalseFalseSIMFalseFalseFalseFalseFalseFalseNaNNaNNaNNaNNaN06a3090553247a9bedc2f856985f71804e65d9400661f1803a302fbae7e8e1f9NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10 a 1513.336986183.26666749.0146.323810145.033333NaN39.563.90000030.03606120.03606120.0NaN21.0NaN51.7333331442448.01442448.0695160.000000695160.000000NaN4.200000NaN41.6722221.442448e+061.442448e+06126.133333210000.0210000.0NaN0.0NaN29.8666671442448.01442448.0ENTIDADES EMPRESARIAISCOMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETASNaNNaNCOMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS48.0NaNNaN6.00.0NaNNaNNaNNaNNaN7.07.00.00.00.00.00.00.06.00.00.03.06.00.00.01.01.00.07.00.00.00.04.00.00.00.00.00.00.06.00.06.000.00.00.021.021.00.07.02.02.07.0NaN2.0NaN2.00.0NaNNaNNaNNaNNaN2.0NaN2.0COMERCIORORO4.866120e+06NaNNaNNaNNaN0.000000210000.0210000.01.442448e+061.442448e+06NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.0NaN0.0